SSAS Live Connection string properties

[magnusneck]

We have a couple of on premise SSAS Tabular cubes that we want to use in Power BI. The cubes have roles with row level filters enabled.

As a developer in Power BI Desktop, with administrator permissions to the cubes, I would like to test the row level filters in Power BI Desktop. When developing the cubes in Visual Studio and testing them in Excel it's possible to connect as another user, and test the roles, with the Roles and EffectiveUserName connection properties when connecting to SSAS. I would like to do this in Power BI Desktop too, but I haven't found how to set such connection properties in Power BI Desktop.

[v-yulgu-msft · Accepted solution]

Hi @magnusneck,

There is no such a functionality that to test role level filters with Roles and EffectiveUserName connection properties in Power BI desktop. You may need to publish the report to Power BI service to test the Role level security settings. Please see:

Tutorial: Dynamic row level security with Analysis services tabular model

Regards,

Yuliana Gu

[magnusneck]

Thanks for the reply!

That was unfortunately what I suspected...

Do you know if there are any good reasons for not enabling this in Power BI? To me this would make Power BI Desktop a good alternative to using Excel Pivot tables when developing and testing tabular models.