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'm trying to get Excel files from a folder and then merge them *after* removing about 100 columns I don't need.
Even trying this on just two files is excruciatingly slow. I'm doing the column removal in the sample file.
Was wondering if there was another way to approach this.
Hi @abertolett,
Maybe you can try Python or R script. But it couldn't be helpful if you have really big datasets. Can you share a sample?
Best Regards,
Dale
Thanks.
Is there any way to modify which Excel sheets are brought into the model *before* doing Combine Files?
It takes forever for Power BI to finish "connecting to Excel".
I'm thinking everything is going to have to be csv going forward.
Hi @abertolett,
There is a workaround.
1. Import a small Excel workbook.
2. Open Advanced Editor in the Query Editor and replace the values 2, 3 in the snapshot with values of the big Excel workbook.
3. Refresh Power BI Desktop.
Best Regards,
Dale
How many columns are you keeping? Might be faster to keep columns instead of remove columns for that many columns. Would also be less prone to error in the event that a column name changes.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |