Forum Discussion
Change to the way Power Query reads Excel files?
- 1 month ago
Hi There,
It turns out that the software we use to apply Sensitivity labels is affecting Excel metadata, rendering it corrupt from Power Query's point of view. As such, we have elected to transition away from using Excel files and will switch to CSV files.
Thanks.
Thanks for sharing the update. Changes to how Power Query interprets Excel files can have a real impact on existing queries, especially when workbooks rely on consistent sheet names, ranges, or inferred data types. One thing I've found helpful is making the import steps as explicit as possible—for example, selecting named tables instead of entire worksheets and setting column data types manually rather than relying on automatic detection. That tends to make queries more resilient when the underlying connector behavior changes in future updates.