PowerBI Asking for Gateway for cloud data sources

[jitparwa]

Hi All.

I am unable to edit my data source credential even my report is referring to cloud data sources.

Refer to screenshot.

[v-qiuyu-msft]

Hi @jitparwa, 

Please add the SQL server data sources in Manage Gateways section by clicking on "Optional- Add to gateway" shown in your screenshot. By the way, please mask sensitive information in the screenshot as this forum is public. 

Please enable the option "Allow user's cloud data sources to refresh through this gateway cluster" for the gateway. Then you can select the gateway for the dataset in Dataset Settings, go to Data Source credentials tab, specify valid credentials for web and OData data sources. 

Reference: 

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

Best Regards,
Qiuyun Yu