Forum Discussion
connect to the same database with 2 different users
HI,
I have encounter the same probleme with Web connector (API) in PowerBi.
Unfortunetly you can't connect the same data source with different credentials in the same pbix file i think.
But an alternative solution you can test (or the DBA administrator)
- In the SQL database you can create a few views who combine data of different company
- This view as a particular shema (different of other tables)
- You can attribute specific acces (read only) in this view using the specific shema
And if a day a new company is create you've just modify you're views ;)
Hope it's help you.
HI,
I have encounter the same probleme with Web connector (API) in PowerBi.
Unfortunetly you can't connect the same data source with different credentials in the same pbix file i think.
But an alternative solution you can test (or the DBA administrator)
- In the SQL database you can create a few views who combine data of different company
- This view as a particular shema (different of other tables)
- You can attribute specific acces (read only) in this view using the specific shema
And if a day a new company is create you've just modify you're views ;)
Hope it's help you.
That's a data solution. Not a pbi solution.
We use oracle. We have multiple users and logins for security purposes. The database is the same. If I use the same db connection it assumes the last login. No options but to change it. For security and access reasons, I need to toggle 3 or more.
Is this is situation where the pbi product isn't quite enterprise ready yet?
Also, what if I'm using ezconnect? Are there any special characters that pbi will ignore and still connect that will fool pbi into prompting me for new user:pass creds?
We're stuck on a POC to replace business objects. I've got BOBJ universe designers thinking this is a major issue and I agree. Any advice is appreciated.