The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi everyone,
I have created a Power BI App which I've shared with some colleagues in other teams, but when they view it (in a browser) there are grey boxes with error messages, even though these don't appear in the version of the app I'm seeing. I haven't purposefully restricted their permissions.
The data for the report that appears in the app is drawing data from the dataset for another Power BI report. This is also part of the same App, but they don't have permission to view those reports.
I think I could solve it by giving them all access to both sets of reports, but that won't wash. We don't want them to see all the data in the source report(/dataset), just the visuals drawing on a subset of that data .
I've looked to see if I can share the dataet, but not the report and there doens't seem to be an option for that.
Anyone got any ideas?
Thanks.
Coriel
Solved! Go to Solution.
Hi,
Since you mention that the dataset from which this report is built, also has another report related to it and both reports are located in the same app, then I presume that the dataset resides in the same workspace as the problematic report.
If that is not the case, then you would have to give users build access to the dataset for them to be able to view the report visuals.
Secondly, is there maybe a Row-level Security (RLS) set up for the dataset? If so, then the users that have issues seeing the visuals might not have been added to the dataset options (three dots) > security page in any of the RLS roles
Hi All
Fisrtly @Rigensis thank you for your solution!
And @Coriel-11 ,are you getting a similar type of grey error to the following?
If you are getting the first grey error, there may be a problem with adding the people in the app, make sure all the people are in are under the same domain.
If you're getting the second grey error, it's likely that you've successfully added a person in the app, but haven't set up access for this person in the semantic model
If you want you don't let the added users see the specific data after you share the report in the app, you can set it in the app whether you can share the dataset or not. In this case, the user can only view the visual objects and can't view the specific data, only see some list names.
I hope my solution can help you, if you have further questions, feel free to contact me, I will reply to you as soon as I see your reply!
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your help. I managed to figure it out.
For the record (and perhaps to help future users) the boxes I was seeing were these ones:
Thanks again,
Coriel-11
Hi,
Since you mention that the dataset from which this report is built, also has another report related to it and both reports are located in the same app, then I presume that the dataset resides in the same workspace as the problematic report.
If that is not the case, then you would have to give users build access to the dataset for them to be able to view the report visuals.
Secondly, is there maybe a Row-level Security (RLS) set up for the dataset? If so, then the users that have issues seeing the visuals might not have been added to the dataset options (three dots) > security page in any of the RLS roles
Thank you that was really helpful.
As you suggested I had to click on the semantic model for that report. Then at the bottom look at the semantic models listed under "See what already exists". Click on each of their 3 dots ••• and choose Manage Permissions and then +Add User
(or you can also do it by clicking on the model itself and go File>Manage permissions> +Add user.).
Much appreciated