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 4 folders created with excel workbooks that follow the same column-level scheme.
When I try to compile files using the binary option, a table is created that only contains data from Ecuador but the other plants are missing.
Alklguien knows how I can solve this problem? or something I'm doing wrong? xq I should generate a table with all countries
The steps I do is go to content, merge taking first file.
Solved! Go to Solution.
Hi, @Syndicate_Admin
Please refer to this document about how to import multiple Excel files in Power BI.
Import Multiple Excel Files In Power BI
Note that in order to combine files Power Query requires that each table structure be consistent.
And if there a link for "Load more" next to the prompt "List may be incomplete",you can also try it to expand the
list.
Best Regards,
Community Support Team _ Eason
Hi, @Syndicate_Admin
Please refer to this document about how to import multiple Excel files in Power BI.
Import Multiple Excel Files In Power BI
Note that in order to combine files Power Query requires that each table structure be consistent.
And if there a link for "Load more" next to the prompt "List may be incomplete",you can also try it to expand the
list.
Best Regards,
Community Support Team _ Eason
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.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |