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
Hello Saludos!
Thank you so much!
Your answer truly made me understand that the problem is not only mine, but general, and therefore it will be solved, I really hope! I also have been struggling with it since morning .. to no avail.
I've already posted to Issues:
https://community.powerbi.com/t5/Issues/Problem-with-Google-data-sources-connection/idi-p/1502104
Please write your comment there and vote for the solution.
Indeed, it is extremely important, because my report is very important for our company and I suppose as yours. It seems similar reports from many users also do not work now.
Best regards
Hello Eugenia. I've been tracking the problem, and it looks like someone found a temporary solution. The solution is to change the privacy level to the original font in Google Sheets, so that it can be seen by "anyone who has the link".
I am a little concerned about this solution, as it slightly impairs the privacy of the data source. I'd like to see if we can contact Power Bi support to see if there's another solution.
I attach the link to the user who found that "provisional solution".
Best regards
Our Issues tickets are the only way to contact Customer Support.
https://community.powerbi.com/t5/Issues/Problem-with-Google-data-sources-connection/idi-p/1502104
We can only wait. In the meantime, I ask everyone who has such a problem to vote in Issues. Please let me know if you know of any other workarounds?
