DataFormat Error: Loading

[stephanieyellow]

Hi all,

I am trying to connect a Google Sheets to PowerBI desktop, and I am using the IMPORTRANGE function on some of those columns in the Google Sheets. When I try to import the data, I get a DataFormat.Error: LOADING error on all columns that use the IMPORTRANGE function. Not sure what I'm to do next.

The details for the error simply say "Loading data...". The number of rows are correct for my non-IMPORTRANGE columns, but for those ones with the error, there is only the header row and the Error cell (where the function is located on Google Sheets).

[stephanieyellow · Accepted solution]

Hi @Anonymous, 

Yes, my PowerBI Desktop the newest version.

Unsure what the final issue was, but when I tested this morning, everything was working properly.

[Anonymous]

Hi @stephanieyellow ,

Is your Power BI Desktop the newest version? Please try upgrading your version to the latest version.

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.