Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have product sales data on Excels. There are 10 Excels with same columns. Traditionally data can be imported to SQL Server by SSIS to concatinate data to table. However I would like to skip DB and use Excel as Power BI data source. Excel files can be located and updated at OneDrive for business.
How to import multiple Excel files to same data model in Power BI?
Hi @Anonymous,
If I understand correctly, there are multiple Excel files exist in the OneDrive for Business, and you want to connect to those files and combine their data into one table use Power BI desktop, right?
Based on my research, you can use SharePoint Folder data source to filter all Excel files within this folder, then extract data from the Content column. Fore detail steps, please refer to this article: Loading Data From Multiple Excel Workbooks Into Power BI–And Making Sure Data Refresh Works After Publishing.
Best Regards,
Qiuyun Yu
Thanks, but I have no SharePoint available. There are files in OneDrive.
I need to concatinate several Excel files with exactly same columns together in Power BI. How to do it? It is in theory possible to use Azure based PaaS services for combining Excels if Power BI cannot do it.
Hi @Anonymous,
I know those Excel files stores in OneDrive for Business. You can also use SharePoint Folder data source in desktop. Would you please take a look at the article mentioned in my original post?
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.