Forum Discussion

MAkiva1's avatar
MAkiva1
Helper I
8 years ago

Google Sheet Loading Error: Downloaded Data is HTML

I've had a Google Sheet connected to PowerBI for a few months now and yesterday the connection stopped working.  When I try to refresh the data I receive the following error:   "The downloaded data...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi MAkiva1,

 

How do you connect the Google Sheet?  Web URL or other?

 

From your error message, Please check your URL.

 

You could reconnect the Google sheet with the URL to check if you could  load the data? 

 

If you cannot connect the data, that should be something with the URL, you should check it and get the new URL.

 

Best Regards,

Cherry

  • MAkiva1's avatar
    MAkiva1
    Helper I
    8 years ago

    I connect via Web URL (adding &output=xls) at the end of the URL. I tried updating the URL it points to and in fact, I've tried creating a new pbix file and starting over and still had the same issue.  Any other suggestions?