The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCustom Visuals Ideas will be in read-only beginning Friday, Feb. 28 as we prepare to move these ideas to the new Fabric Ideas.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.