User Profile
kmes912
Helper I
Joined 6 years ago
User Widgets
Contributions
Re: Row-Level Security Members Updating - Creative Solutions?
HI GilbertQ yes it works properly when I test as role. But if I do not manually add the user in the Power BI Web Service under the "Row Level Security" Security manually one by one, they cannot see anything. It just shows a blank screen saying Row Level Security has been applied. I'd like to add everyone in my organization, then let the actual dynamic row level security dictate it but cannot figure out how to without manually adding everyone to "Security"Row-Level Security Members Updating - Creative Solutions?
Within Power Query, I am dynamically pulling users emails & access to "unit" based on the latest access that they have in another system. Set this to my master list of units, Many (Security) to One (Master List of Units) with cross filter both and apply security in both directions. It works when I test but was not working in the service for other users or behaving as expected. I ended up publishing it to My Workspace to see if it was a matter of access. The users get the row level security error and are unable to see any visuals unless I add them to to the "Security" group within the web service. Anyone have creative solutions around maintaining this? I do not have Microsoft 365 Admin access in my company. Are there alternative dummy groups I can set up? Since the access is dynamic and lives within the PBIX file, I do not care who has access to the group so really I want every person possible in this "Security" group since it will filter out anyone through the actual row level in the report. But also want to keep this clean to not have to manually update this weekly/monthly/etc. Willing to test workspace, app access, but this seems like yet another that we have to update. Is this just an admin task you have set to do every time you grant a user access to the app?Performance issue with one specific measure
I have a matrix that has 9 column across, 3 levels to drill down + signs. When loading all visuals on the page without this "filter" it loads fine, Dax Query renders in 87 ms in the matrix for performance analyzer. When loading all visuals on the page with this "filter" it loads very long, Dax Query renders in 30,239 ms in the matrix for performance analyzer. This is the only change that has been made with both when running Performance Analyzer. It also behaves similarly if I remove the 9 columns across and only go to 1 column. The filter in question is a simple adding three of the columns together and is set to "is not 0" for the visual filter in order to remove duplication in the + sign rows (there are 0's across that I am trying to eliminate). I don't know what the next steps are for analyzing, I know this filter is the reason but cannot understand why this one filter would cause such performance issues as it is not anything special or unusual (and all three of the fields in it are already in the matrix).
