Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Greetings!
I'm importing a folder with a series of sheets in xlsx format., I'm not having problems with the error dataformat.error 'text' is an invalid xmlnodetype.
I tried to create a custom column then use Excel.Workbook containing, "Excel.Workbook[Content]), but the problem was not resolved as seen in the image below.
I make available the files that I need to be read: https://drive.google.com/drive/u/0/folders/10RNAAKY2IQJbcHzocw58rBHOtNFyqLij
I need help trying to solve this problem and be able to read this spreadsheet database in Power Query.
Thank you very much in advance! 🙂
Solved! Go to Solution.
Hi @jbwtp
In fact, it was wrong to write the code, however when fixing it, I still can't join the tables.
Until then, the solution I got was transforming the spreadsheets into CSV by VBA, so that after that I could perform the reading within the Power Query correctly, this generates more slowness within my automation via python, but it was the best solution so far time.
Thanks so much for the feedback anyway! 🙂
Hi @jbwtp
In fact, it was wrong to write the code, however when fixing it, I still can't join the tables.
Until then, the solution I got was transforming the spreadsheets into CSV by VBA, so that after that I could perform the reading within the Power Query correctly, this generates more slowness within my automation via python, but it was the best solution so far time.
Thanks so much for the feedback anyway! 🙂
Hi @Hammerschmidt,
I think that you should have the column reference in brackets:
Excel.Workbook ( [Content] )
Kind regards,
John
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
35 | |
17 | |
12 | |
11 | |
9 |
User | Count |
---|---|
45 | |
27 | |
16 | |
14 | |
13 |