Forum Discussion
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?
Hi, mnogolosos
Google Sheets does not need a gateway to refresh.
Power BI data sources - Power BI | Microsoft Docs
For your preoblm:
You need to confirm the setting is turned on in gateway setting.
Also, you need to update the data source credentials in service>>dataset >>setting.
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
2 Replies
Hi, mnogolosos
Google Sheets does not need a gateway to refresh.
Power BI data sources - Power BI | Microsoft Docs
For your preoblm:
You need to confirm the setting is turned on in gateway setting.
Also, you need to update the data source credentials in service>>dataset >>setting.
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 _ JaneyHi, 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