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
10 years ago

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?

 

nirrobi's avatar
nirrobi
Helper V
10 years ago

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)!

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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.

    • nirrobi's avatar
      nirrobi
      Helper V
      10 years ago

      I have access to all users and companies. 

      I am not sure i am able to create one "super user" as you recommend but I will try. 

       

       

      • Haegi's avatar
        Haegi
        Advocate V
        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.