Cloud data sources adding under Data gateway

[Anonymous]

Hello All,

1. I have composite data model which is having data sources form onprem and cloud. When I ublish theis dataset to power bi service. Cloud data sorces were showing under data gateway. I have no clue why this is happening.

2. I have configured the data sources perfectly but when I refresh the dataset its showing the error as cloud data sources cannot be added under data gateway.

Please help on how to delete this data sources under dtagateway. If you any other solution to make this dataset refreshed please help me. Thanks in advance.

[JoeBarry]

Hi @Anonymous 

Normally you wouldn't need to add a SharePoint list to the Gateway. They appear there because the SQL source do require a gateway, but this doen't mean that you have to map them to it. The Red x is ok in this situation.

Is it possible to delete the report from the Service and upload again? If yes, please do that, then go to the Gateway sources and remove the Sharepoint and Dataflow sources from it. Upload again, map the SQL Sources only to the gateway and click apply, you may be asked to add credentails again, do that if prompted.

Thanks

Joe 

If this post helps, then please Accept it as the solution