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 am trying to combine around 1000 excel workbooks. However, It does not get combined due to some error which I don't know.
Then I try to add custom column and write Excel.Workbook([Content]) and I get the following:
Some are Table, the rest are ERROR.
All excel workbooks I am trying to import have same format.
Due to this Error, I cannot Combine and Edit the binary upon Import.
When I double click in the Error. I get the folloing message, but the workbook is correctly in excel format.
Thanks for support!
Solved! Go to Solution.
Hello, I found a soultion. The files had some errors in it (files arrived through an automated system in excel 97-2003 version). But when I open and save the file in excel, the error disappeared and appeared as table in PowerBI and could combine all.
So I opened and saved all in mass with a Macro. Now all is OK.
Thanks you anyway.
Hi,
Share a couple of sample workbooks which are showing an error in the Custom column. Please ensure the file sizes are small.
Hello, I found a soultion. The files had some errors in it (files arrived through an automated system in excel 97-2003 version). But when I open and save the file in excel, the error disappeared and appeared as table in PowerBI and could combine all.
So I opened and saved all in mass with a Macro. Now all is OK.
Thanks you anyway.
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 |
---|---|
100 | |
99 | |
76 | |
67 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |