Showing results for 
Search instead for 
Did you mean: 
dmule Occasional Visitor
Occasional Visitor

Cant refresh dataset from Google Sheets - failed to connect to gateway

Ive imported my data in the desktop app but am unable to refresh the data in the web app. Ive published my sheet to the web (ive tried both html and xlsx - both with different errors) and set up a gateway as follows with the correct credentials...


 data source.jpg

However Im getting the following error..




I feel like ive tried all options and am at a dead end. please help. Thanks.

Community Support Team
Community Support Team

Re: Cant refresh dataset from Google Sheets - failed to connect to gateway

Hi @dmule,


Based on test, I can use connect direct mode to connect google sheet with anonymous credentials.


Can you share more detailed info about this?

BTW, if you are try to create report with merged datasources, I think you can try to use personal gateway to instead.




Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 211 members 2,114 guests
Please welcome our newest community members: