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.
If I am understanding this correctly, what you want to do is create a Content Pack in the service and put your data set and report in that content pack. Then, you can share that out with your users and they can load the content pack into their Power BI. Each user could then set the credentials on the data source to their own. You could do the same thing by sending copies of the PBIX file to each user and have them set the credentials on the data source to their own.
Thank for the reply.
For now the power bi project in our company is "one men show" (me :-)).
I was able to establish reports and dashboard for one company- great success
but now the other related company want to implement the power bi - no problem for me (I think) and the owner want to create one dashboard that make comparison between the companies- I need to have data for 3 companies in the same report - (one databease for the group with different user and password to every company).
I am not familiar yet with content pack but from what I read (and hopefully understood) it not what I look for.
How are you splitting up the data in the database? Are you exposing different schema's and tables to each company, and they only see their own tables? Or are you using some other method like row level permissions?
Hi.
As much as I know we have diffrent table to each company (company name.table name)(almost the exact tables to all of the companies)
In our operational system every user see only his company (tables) but I need to make comparison to all of the companies so need to connect to the same database with different user 3 time in the same report.
Is it possible at all using the power bi?
we succeed to implement this method in powerpivot but till now no success in power bi.
Many thanks (again)!
If you have access to read all the companies (with seperate users), why not just create one read-only user on the SQL database that has access to read all company tables?
I haven't tested out the scenerio of trying to connect to the same source multiple times with different credentials yet, so I can't speak to that.