Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Use different data sources with the same database and different credentials

With Reference to Add two different credentials for same data source in Power BI Service , add ways to have different data sources that point to the same database and with different logins. Use case: Using Row Level Security (RLS) by login on a single database, so use same database source for different pbix with the same login, so when working in Desktop the credentials don't have to be re-entered for each login in different pbix sessions plus the data source can be identifed with a parameter and point to different logins, possibly allowing the same pbix to be used with different logins.

Note that attempted to use alias urls to work around this, however with a PostgreSQL database and SSL this doesn't work because it results in a certificate error and the main database is an AWS RDS which we can't modify the root certificate of.

Status: New