Forum Discussion
'Unable to connect to data source undefined'
Trying to refresh a dataset from 3 different sources - two are databases within the same server and then one additional server. All have been set up with the gateway I'm using. I haven't seen the...
I had the same issue. In my case the problem were 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
That's brilliant, worked for me, thanks very much.
