Forum Discussion
How to use SSAS with Dynamic RLS as a data source for PBRS?
Hi Anonymous,
Please refer to jtarquino's reply in this thread. After configuring RLS on resource side, and publishing reports to Power BI report server, set the data source credential to "As the user viewing the report".
Regards,
Yuliana Gu
Hi v-yulgu-msft,
Thank you for answering me. I have already done these steps. I wrote before, Direct Query to a SQL statement is not a viable solution because of the amount of the data. I always use the "As the user viewing the report". But for SSAS, this option doesn't filters the rows according to the role included into SSAS Tabular. I was wondering if there is a keyword that I need to use in the connection string to let the SSAS Tabular knows that I want to use the role that I have created?
Lets say that you have created a SSAS Tabular (let's call it a "cube") with Role1 that filter using a certain logic and Role2 taht filters using a different logic. How would you tell Power BI to select Role1 for example? Am I misunderstanding something?
Anonymous did you find a solution for this?
vmn0620: Nope. I have contacted directly several members of Microsoft and noone knows to achieve that. They assume that Report Server Power BI recognises the roles created in SSAS when actually it doesn't. Quite frustrating to be frank.:smileyfrustrated: You can get a SSRS report on a PBRS to recognise the roles (using the connection string keyword "role") or even Excel to recognise it, but not Power BI.
Has this resolved in the new version of PowerBI? Can PowerBI recognise the SSAS Roles?
