Two data sources in Power BI Service: "Unable to connect to the data source undefined"

[MIkkelHyldig]

Hi all,

Is it possible to combine on-prem data source A using a gateway with data source B using Azure cloud without gateway in Power BI Service?

I get the error "Unable to connect to the data source undefined" when refreshing the dataset in Service.

Both privacy levels are organizational but source A is using a windows credential while B use organization credential. 

Thanks, 
Mikkel

[MIkkelHyldig]

Dont know yet 🙂 I will let you know

[v-yalanwu-msft]

Hi, @MIkkelHyldig ;

Thank you for sharing, so your problem has been solved?

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

[MIkkelHyldig]

Hi again @v-yalanwu-msft ,

okay so I backtracked the report and the error message happens when I publish the report with a flat table created in Power BI MERGED to an existing table from my cloud source. 
It seems strange that it gives me this error message just for merging a flat table on the table..


Regards, 
Mikkel
 

[v-yalanwu-msft]

Hi, @MIkkelHyldig ;

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,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MIkkelHyldig]

Hi @v-yalanwu-msft 
It did not fix the problem but I found this thread explaining possible roots and solutions to the issue: PowerBI intermittent Refresh Failure - Unable to c... - Microsoft Power BI Community