Forum Discussion
How to use SSAS with Dynamic RLS as a data source for PBRS?
Please could you tell me how to use SSAS Tabular 2016 with Dynamic RLS as a data source for PBRS? I have more than a thousand of users with their logins and respective security level in a table. Eac...
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?