Forum Discussion

nirrobi's avatar
nirrobi
Helper V
10 years ago
Solved

connect to the same database with 2 different users

Hi all,   I have in my company database for 5 companies. Every company has diffrent user name and password but all of them connect to the same database. I succceed to create stunnig report to my c...
Need Help
  • Haegi's avatar
    Haegi
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

This is a real issue and I treat it as a bug. 
If I have different reports with own datasets in different workspaces why the connection to the same database is always goes using one of the connection string?  
Why do you have a different dataset at all in such case? Just allow only one. I suspect your internal optimization to reduce the number of connections caused this issue, but it should check additionally authorization parameters, not only database name and server.

I want to restrict access to the sensitive data in multitenant SaaS application which uses the same database shared schema and I have no choice. And please don't offer me Row-Level Security, because report designer in such case have access to the data which he shouldn't.
This is really weird when cloud multitenant SaaS application designed in a way to the on-premise app. This is not "cloud-first" approach.