Skip to main content

Power BI

Needs Votes

data set specific credentials do not work for same data source

Vote (2) Share
Sai Sathyavaram's profile image

Sai Sathyavaram on 17 Dec 2020 07:17:19

Hi there

I have multiple workspaces in power bi service. In each workspace there is one data where one report is built on top. The source of these different data sets in the different workspaces is always the same PostgreSQL database. However, I use different views in this PostgreSQL database and different credentials such that each report/data set in power bi can only access one dedicated view. Moreover, I set the privacy level to private for these data sources.

The problem is, that I receive the error message "The key didn't match any rows in the table." in the scheduled refreshment. It seems like there is a problem when using different credentials in different reports