Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mnogolosos
New Member

Cannot add Google Sheet to a gateway (automatic refresh)

I have a data in my report from a sqlserver, also I've added data from a google with a google sheet beta, but now I can't set up an automatic refresh, because the google sheet cannot be add to a gateway:

 

Extension{"extensionDataSourceKind":"GoogleSheets","extensionDataSourcePath":"https://docs.google.com/spreadsheets/d/<...>"}Cannot be add to a gateway

I red this article https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud and did all the steps but didn't help.

Can anyone help to solve this issue?  

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @mnogolosos 

 

Google Sheets does not need a gateway to refresh.

vjaneygmsft_0-1641887894814.png

Power BI data sources - Power BI | Microsoft Docs

For your preoblm:

You need to confirm the setting is turned on in gateway setting.

vjaneygmsft_1-1641888157386.png

Also, you need to update the data source credentials in service>>dataset >>setting.

vjaneygmsft_2-1641888640742.png

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
 
Best Regards,
Community Support Team _ Janey

View solution in original post

2 REPLIES 2
v-janeyg-msft
Community Support
Community Support

Hi, @mnogolosos 

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your problem.
 
Best Regards,
Community Support Team _ Janey
v-janeyg-msft
Community Support
Community Support

Hi, @mnogolosos 

 

Google Sheets does not need a gateway to refresh.

vjaneygmsft_0-1641887894814.png

Power BI data sources - Power BI | Microsoft Docs

For your preoblm:

You need to confirm the setting is turned on in gateway setting.

vjaneygmsft_1-1641888157386.png

Also, you need to update the data source credentials in service>>dataset >>setting.

vjaneygmsft_2-1641888640742.png

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
 
Best Regards,
Community Support Team _ Janey

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.