PowerBI Service Same report on different workspaces connection overlapping issue.

[Anonymous]

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,

[v-ljerr-msft]

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. 

Regards

[GilbertQ]

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?