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.
Hello,
I have etablish a connection between a share folder in o365 sharepoint with power BI.
Now I have multiple excel files (here named Table), and I want to load every table into separate queries. Power query can combine them but I don't find who to separate them not manualy in different query.
My objective after this is to clean the data into each queries because excel file are not clean to use it in power bi. Other wise, if there is one query I can't use relationship table because they will be only one table.
Thank you !
Solved! Go to Solution.
@frostys,
Right click each row and select "Add as New Query " to create separate queries for these Excel files.
Another option is to import each Excel file into Power BI. And you can create filename parameter listing all Excel files in Power BI Desktop, then add the parameter into your web URL. This way, you can get different queries by selecting different files from drop down.
Regards,
Lydia
I am doing the same steps but when I do this I get one file correct and the other files with all the columns with NULL¡¡¡ how to correct this? I need to load all the csv files without combine¡¡ HELP please
@frostys,
Right click each row and select "Add as New Query " to create separate queries for these Excel files.
Another option is to import each Excel file into Power BI. And you can create filename parameter listing all Excel files in Power BI Desktop, then add the parameter into your web URL. This way, you can get different queries by selecting different files from drop down.
Regards,
Lydia
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.