cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AndrewNg New Member
New Member

Power BI dataset refresh failed with "Unable to connect to the data source undefined."

Hi,

 

Starting about 1-2 weeks ago, my PowerBI dataset's refresh has started to fail with the "Unable to connect to the data source undefined" error.  It was working fine before and we have not changed any setup on the PowerBI, data gateway or backend SQL server side.

 

PowerBIRefreshError.png

 

However there are a few times that it can work successfully, by manually triggered or scheduled.  So the underlying plumbing seems to be okay.  But the current situation is that most of the scheduled refreshes would fail, which is seriously impacting our business users in Production...

 

PowerBIRefreshErrorHistory.png

 

Any help on this would be appreciated.

 

Thanks,

Andrew

 

1 REPLY 1
Community Support Team
Community Support Team

Re: Power BI dataset refresh failed with "Unable to connect to the data source undefined."

Hi @AndrewNg 

 

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

 

If it is not your case,you may submit a support ticket.

https://powerbi.microsoft.com/en-us/support/

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.