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

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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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.