Forum Discussion
Static RLS not showing data in Power BI Service
Hi GilbertQ,
That explination made total sense, thank you again. I was able to resolve the issue by modifying the DAX using the double pipe ||. Allowing me to add the additional office locations to a single RLS role, then assigning the appropriate people to that single RLS role.
Example: [Office Name] = "XXXX" || [Office Name] = "YYYY"
Hope this may help others! Thank you again!
Hi DeanUW
As far as I am aware this is not possible and you need to have the users in a single role.
The update was for Power BI Composite models to the Mashup connectors include Snowflake, RedShift, Databricks, and others.
Power BI July 2022 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI
Hello GilbertQ
Thanks for the response. Below is a quote from the July 2022 Feature Summary you attached to your response to me:
"We’ve also made a major improvement to composite models this month by enabling support for multi-role RLS. Model owners can now assign a single user to more than one RLS role in a composite model. Prior to this release, users who set up RLS in their composite models this way would likely hit a query failure."
Seems to me the feature isn't working as promised.
Hi DeanUW
As per the link this is only for Composite models who connect to data sources OUTSIDE of the Power BI Service.
Apologies I am still somewhat new to Power BI. By my understanding the report in question is a composite model; as it has multiple many-to-many relationships within the tables and it has mutliple sources including ODBC imports from different databases and Excel spreadsheets. As always, I appreciate the responses & the support!