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.
I have set up row level security, and it is working as it was suposed to
then we got more reports, and instead of sharing each report with 50 persons, we made a sharepoint groupe
so we have he sharepoint group "finance"
- now my problem is that every member in this groupe is ignooring the row levle security -
is this a feature or an error ?
and am i doing the whole sharePoint thing wrong
Yes they log in via powerbi.com with their own credentials, and if i only share the repporte it works perfectly, but if i add them to the groupe "finance" on the SharePoint Server, the now can see beound what ther role was normaly limited to.
The simple solution is ofc to remove ALL persons from the sharePoint groupe and go back to manualy distributing 10 reports among 300 people... 😞
Solved! Go to Solution.
"
If you publish your Power BI Desktop report to a workspace within the Power BI service (such as Sharepoint), the roles will be applied to read-only members. You will need to indicate that members can only view Power BI content within the workspace settings.
How to set this :
on the power Bi portal :
Click the 3 dots at the end of the workspace name - select "edit work space"
in the new window:
Select members can only read
"
If you publish your Power BI Desktop report to a workspace within the Power BI service (such as Sharepoint), the roles will be applied to read-only members. You will need to indicate that members can only view Power BI content within the workspace settings.
How to set this :
on the power Bi portal :
Click the 3 dots at the end of the workspace name - select "edit work space"
in the new window:
Select members can only read
You may take a look at the post below.
I still dont get it
There is no where i see the "membership of Sharpoint will override rowlevel security" or ... any thing similar.
All i can see is that this is the result - and i dont know how to stop it.
one of the articles are 5 pages on how to generate tokens and so on... we dont do that (yet) since we only use it internaly.
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.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |