Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
151
Views
Topic starter
Hi,
I sometimes have an issue, to import data into PQ from an .xlsb file from a synched One Drive folder, but the same data work, if I save the file as .xlsx.
Is this a known issue?
best regards
Christoph
Posted : 12/02/2021 4:47 am
Hi Christoph,
It is far more efficient for Power Query to connect to .xlsx files than it is for .xlsb files. I wonder if your file is large. If so, it's recommended that you save your file as a .xlsx for the purpose of importing to Power Query. You might want to try saving it as .xlsx to see if that resolves the issue.
Mynda
Posted : 12/02/2021 6:00 am
