Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Goal:
Share an app OR report to the entire organization where users will NOT be able to build on the underlying datasets that use composite model (i.e. Mixed) AND direct query to chained Power BI Datasets. It seems it should be possible when reviewing the cited documentation below for composite model and direct query on a workspace with premium capacity
Issue:
When a user that has direct access to an app views the report, they first are prompted by a schema message (issue image #1) and then the visuals do not load on the report page (issue image #2) and when you click on see details you get another issue popup (issue image #3)
Issue Image #1
Issue image #2
Issue Image #3
Note: I CAN get the user to see all the app content with no errors, but I must make them CONTRIBUTOR or higher on the WORKSPACE for the app and I do not want to give them that high level of permission. Also, I have an Admin in my workspace that confirmed he sees fine as well.
I did review the following sources in helping troubleshot with multiple tests and multiple users but could not land on a solution for read level access distribution of the app or report.
Also, I think this might be related to this post
Tests I have tried with no success for users in my organization where I believe we are all on premium capacity
App Details
Workspace Details
Name: Workforce Reporting [Production]
Other notes
Dataset Details
See data lineage view
Solved! Go to Solution.
I was able to narrow in on the issue. In short I needed to add users to a group in RLS on one of the Power BI Datasets that is a direct query data source in the chain.
For reference
Dataset permissions - Power BI | Microsoft Docs
I was able to narrow in on the issue. In short I needed to add users to a group in RLS on one of the Power BI Datasets that is a direct query data source in the chain.
For reference
Dataset permissions - Power BI | Microsoft Docs
Fantastically detailed request, @bwarner87 . I'm here this morning looking for info on how to give users edit access to a Scorecard in a workspace without giving those users at least Contributor direct access to the workspace, which then gives them access to a report in the same workspace that I do *not* want them able to access. I'm setting up audiences, but that doesn't seem to be my solution. I hope any replies to your message help me as well. Thanks for doing this work! And good luck!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
48 | |
28 | |
20 | |
20 | |
19 |
User | Count |
---|---|
51 | |
51 | |
26 | |
25 | |
20 |