Problem with data sources connection in PBI Desktop

[EugeniaBochko]

Hello! I have a big problem with data sources connection in PBI Desktop, especially WEB page from Google Spreadsheets.

Today I come across with this problem with my existing data, I have been working for a year with these sheets and everything was OK:

“The URL may be wrong or you might not have provided the right credentials to the server.”

As usual I Publish to the web my online Google sheet) and then I get new Web data to PBI Desktop and nothing =(..I have an empty window. PBI displays:

"We didn’t find any tables on this web page. No items selected for preview."

http://prntscr.com/vlgucs 

http://prntscr.com/vlguos

Please let me know how to overcome this issue.

[guillermosantos]

Although as I mentioned, from my point of view the solution is temporary. No one likes your data to be exposed.

[guillermosantos]

Hello, the change in privacy is in Google Sheets, not Power Bi. That's how it worked out for me.

[Anonymous]

I am having this same error in a database that should be refreshed daily. 

I tried the change in the privacy level but also did not work.

I hope it is fixed soon.

[Anonymous]

I´m having this problem too. Some dashboards updated, but others no.

[guillermosantos]

Hello Svaida.

In the previous message I commented on a solution, although I find it temporary and a little uncomfortable as it involves "unprotecting the data source".

Did you find anything else?

Best regards

[Anonymous]

I didn´t find anything.

I think it is a problem leaving the data unprotected. 

I hope they solve this soon.

[Syndicate_Admin]

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

https://prnt.sc/vliq2u

[EugeniaBochko]

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 

[guillermosantos]

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

https://community.powerbi.com/t5/Issues/DataSource-Error-The-downloaded-data-is-HTML-which-isn-t-the...

Best regards

[EugeniaBochko]

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

https://community.powerbi.com/t5/Issues/DataSource-Error-The-downloaded-data-is-HTML-which-isn-t-the...

https://community.powerbi.com/t5/Issues/Google-sheet-data-download-stopped-working-today/idc-p/15041...

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?

[amitchandak]

@EugeniaBochko , I saw one more issue with google analytics. Please check and log an issue if this is happening post Nov 2020 Update -https://community.powerbi.com/t5/Issues/idb-p/Issues