Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.