Forum Discussion
New Excel file format has different navigation steps?
Something changed with the Excel exports from our Oracle system, and IT does not understand. Previously, the Excel.Workbook function returned five columns (Name, Data, Item, Kind, Hidden) and Nav...
Hi dps ,
You can try the following steps to troubleshoot the issue:
- Check if the Excel file is corrupted. You can try to make a small edit and save the source file to see if it fixes the issue.
- Check if the file format has changed. You can refer to the documentation on how to troubleshoot connector and format issues in mapping data flows.
- Check if the numeric data is changed when imported from Oracle datasource. You can refer to the documentation on how to troubleshoot this issue.
- Check if the M query is causing the issue. You can refer to the documentation on how to troubleshoot drill through in Power BI Desktop and Power BI Service failing due to data refresh load.
- Check if the CSV files coming from SharePoint online Folder are causing the issue. You can refer to the documentation on how to troubleshoot refreshing CSV files coming from SharePoint online Folder.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Yes, making the small edit and saving will fix the issue. However, we use daily Dataflow refreshes on many different daily exports. So it is impractical to do this for every file every day. Given that this manual step does allow the file to be read though - does that offer any insight into what the originating problem is? What does that say about the xlsx file? What could be happening in our Oracle financial system that causes it to export corrupted files?
- The format is still xlsx, before and after this issue
- The data did not change, and the error happens during a step before analyzing individual fields/columns
- The M query still works with the older exported files, so that is not the issue
- It is not a CSV. It is an xlsx file.