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 all,
I have an issue when loading an Excel file into PowerQuery: we receive a sales forecast file from an external partner that contains 18 columns of data. When I try to load this .xlsx file PowerQuery only recognizes 17 columns - the 18th column is not showing (which is a column I actually need). If I make a small modification to the original Excel file (e.g. as simple as just adding a random number to a random cell in any of the worksheets, not even the one I need) - the last column is recognized 🤔.
Attached a print screen of the behaviour of both orginal file behaviour and after modification behaviour.
Did anyone experience this before and has a potential workaround (other than modifying and saving the file like I do today). I have a PowerAutomate solution running that saves the Outlook attachments automatically upon receipt and would like to avoid any manual intervention to the files.
Thx a lot for your feedback!
Kind regards,
Michiel
Solved! Go to Solution.
Hi @MichielJansen ,
I cannot reproduce this issue on my side, here is a similar case for your reference.
https://community.powerbi.com/t5/Power-Query/MIssing-last-column-in-Power-Query/m-p/786933
You could also log an issue at
https://community.powerbi.com/t5/Issues/idb-p/Issues
Hi @MichielJansen ,
I cannot reproduce this issue on my side, here is a similar case for your reference.
https://community.powerbi.com/t5/Power-Query/MIssing-last-column-in-Power-Query/m-p/786933
You could also log an issue at
https://community.powerbi.com/t5/Issues/idb-p/Issues
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |