The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
77 | |
76 | |
36 | |
31 | |
29 |
User | Count |
---|---|
93 | |
81 | |
57 | |
48 | |
48 |