Fixing error in refresh (Dataflow consuming through SqlServer and SharePoint)

Hi Anonymous 

I think the error is probably caused by SqlServer data source rather than SharePoint data source. Usually you don't need to add a SharePoint online data source to the gateway as Power BI service can connect to SharePoint cloud service directly. Based on my test, although it shows X beside the SharePoint data source (because I don't add it to the gateway), I can still refresh the dataflow correctly.

The credentials for data sources added to the gateway are managed on Manage gateways page, while credentials for data sources not added to gateway are managed on dataflow settings page (the data source credentials section you see).

So I suggest you go to Manage gateways page (by clicking the gear icon) and check whether the gateway is connected to the SqlServer data source successfully. If not, it will show error message there. You can then troubleshoot according to the error message.

Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.