Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

PowerBI Service Same report on different workspaces connection overlapping issue.

Hello,

 

I have deployed one report on 2 workspace with same sql server but with diffrent user. for user level security we have view at the dataabase level which is filtering the data based on user sql connection.
 
Now the problem is both the workspaces reading only one connection  with single user even though i have set up connection with diffrent user. so basically i am seeing same data in both the workspace report.
 
Report have Azure sql live connection but tried with import option also its not working.
 
Whats is the issue here ?
 
 
Thanks,

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    8 years ago

    Hi Anonymous

     

    What I think you would need to do, is to create 2 seperate connections via the Gateway, and then when you create the connection you can specify the required user?

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    It seems to be that configuring multiple credentials for the same Database in Power BI is not supported currently. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments to improve Power BI on this feature. :smileyhappy:

     

    Regards