Forum Discussion
Gateway connectivity issue
Hi Team,
I am trying to refresh the power bi report which was developed from google sheets input data. I published it to service and trying to connect gateway for it. But while i an trying to do gateway connection it throwed me below error. Please help me here.
Details: onpremgateway: Value cannot be null. Parameter name: uriString Please have this information handy if you choose to create a support ticket. Session Id: 07ecff8e-85fa-4ffe-b42a-2619c03ce501 RequestId: 5d60397d-5e0e-4153-9b4e-a5b2d537c2ec Cluster URI: https://api.powerbi.com Status code: 400 Time: Wed Sep 20 2023 12:27:24 GMT-0400 (Eastern Daylight Time)Please have this information handy if you choose to create a support ticket. Session Id: 07ecff8e-85fa-4ffe-b42a-2619c03ce501 Cluster URI: https://api.powerbi.com Time: Wed Sep 20 2023 12:27:24 GMT-0400 (Eastern Daylight Time)
Hi hchava1104 ,
Because Google Sheets is a cloud data source, after you create report in Power BI Desktop and publish it to the service, you need not create the data source for gateway, you just need to set the credentials for the dataset under dataset settings, then you could refresh.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi hchava1104 ,
Because Google Sheets is a cloud data source, after you create report in Power BI Desktop and publish it to the service, you need not create the data source for gateway, you just need to set the credentials for the dataset under dataset settings, then you could refresh.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.