Forum Discussion
Refresh Failure ; Unable to connect to the data source undefined. My sql
gateway connection is fine... everything was fine my side bt i got below issue... please sort me out team... i tried lot many ways..
7 Replies
Hi Anonymous ,
There is a similar posts which you can refer to:
Or please check if the credentials of the data source are expired
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
It seems that the crendential of your data source and your gateway both got problems.
First, check your gateway if it is installed successfully and you need to keep the gateway version the latest.
There're some considerations about gateway: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install#related-considerations
Second, when you make sure your gateway works, you may check the different privacy level settings in Power BI Desktop and Power BI Service. Make sure you have the same privacy level security:
In Power BI Desktop:
Options and Settings --> Data Source Settings
For every Datasource: --> Edit Permissions
Set Privacy Level: e.g. „Organizational“
Power BI Service:
Datasets --> (Choose you Datasets which does not update properly) --> settings --> Gateway Connection --> Actions --> (expand you cluster to show all Data Sources) --> (Choose relevant Datasource) --> Advanced Settings --> Privacy setting --> set same level (e.g. „Organizational) as in Power BI Desktop
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.