Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
So from my understanding of how this report works, it uses OAuth2 authentication which is based off of my credentials.
My credentials have been given access to Different AutoAttendant and Calling Queues.
If I open it up in the desktop then it shows me the proper information.
If I put it on the power bi service then I also have to use my credentials in the Semantic Model Refresh. This will show me the data for the teams access I've been provided as well.
However, is there not a way to have this report pass through the users credential so that everyone sees there own teams assignments and not the assignment of the credentials used to refresh the data?
Or is the intent of the report that you have one account that is assigned everything and the user then filters the report based on the Call Queue and Auto Attendent pull down lists.
Thanks for your assistance.
Sean
Hi @SeanMoody
In Power BI, the process of refreshing the data and the way users access or view the data are handled separately.
Data refresh is managed through the on-premises data gateway (if needed) and is configured with organizational-level credentials. The refresh runs automatically on a schedule, or manually when triggered, and always uses the credentials defined in the dataset settings – not the credentials of the user viewing the report.
Access to data within the report is controlled using Power BI's internal Row-Level Security (RLS). With RLS, each user sees only the data they're authorized to view, based on the security rules you've defined.
So even though one account is used for data refresh, each user can still see only their relevant information if RLS is implemented correctly
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
81 | |
75 | |
70 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
52 | |
43 | |
42 |