The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to Solution.
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.
Hi, @mnogolosos
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.
User | Count |
---|---|
37 | |
14 | |
12 | |
11 | |
8 |
User | Count |
---|---|
49 | |
36 | |
22 | |
21 | |
18 |