January 31, 2019
July 16, 2010
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.