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

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 406 members 3,447 guests
Please welcome our newest community members: