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 different datasets at all in such case? Just allow only one. I suspect this is 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.