Gateway connectivity issue

[hchava1104]

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.

Unable to create connection for the following reason: There was an error in the data gateway.

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)

[Anonymous · Accepted solution]

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.