Forum Discussion
Problem with data sources connection in PBI Desktop
Hello Eugenia:
I was going crazy with the mistake, I thought it was the only one that happened to him. I have an implementation similar to yours and I get exactly the same mistake. In fact, my data source is also hosted on Google Sheets and I have a dashboard in Power BI Online that was automatically updated (daily, several times a day) with my Google credentials. However since yesterday I have started to get notices of failure when updating, without me touching anything on my Google Sheets data source. You can no longer upgrade.
When I connect to my original file in Power Bi Desktop, I get that error that the file is an "HTML, and it's not as expected". I guess Google will have changed something that has made it incompatible to read your files in xls format, or that Power Bi changed something.
I guess they'll be working on the mistake. It must be something internal to the Power BI platform. If you know anything please let me know, why am I concerned as my Dashboards presenting the problem are used to control several of my company's processes.
Best regards