Forum Discussion

stephanieyellow's avatar
stephanieyellow
New Member
3 years ago
Solved

DataFormat Error: Loading

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).

Need Help
  • stephanieyellow's avatar
    stephanieyellow
    3 years ago

    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.

2 Replies

  • stephanieyellow's avatar
    stephanieyellow
    New Member
    3 years ago

    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's avatar
    Anonymous
    Not applicable
    3 years ago

    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.