Forum Discussion
Fabric and excel files
Good afternoon, please help me with advice. There is a report in Power BI, the source is data from Excel files from SharePoint. There are more than 500 files, every day there is a new one with a n...
pmreis
Most Valuable Professional
Most Valuable ProfessionalHi Anonymous
Microsoft Fabric is certainly capable of handling a large volume of files and data.
I'd recommend that you go through the lakehouse and warehousing tutorials:
Tutorial name Scenario
| Lakehouse | In this tutorial, you ingest, transform, and load the data of a fictional retail company, Wide World Importers, into the lakehouse and analyze sales data across various dimensions. |
| Data warehouse | In this tutorial, you build an end-to-end data warehouse for the fictional Wide World Importers company. You ingest data into data warehouse, transform it using T-SQL and pipelines, run queries, and build reports. |
Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple
If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!
Find me at LinkedIn