topic Re: Passing filter values to a Power BI report in Power BI Report Server in Report Server

Passing filter values to a Power BI report in Power BI Report Server

gourangib — Wed, 25 Oct 2017 03:33:07 GMT

I have designed a dashboard using SSAS live connection and hosted it on power bi report server. Now i want to give access to the dashboard on the basis of a role of a logged in user. e.g. If Regional Manager of South has logged in and viewing dashboard then he should be able to see data of only southern cities and so on. I have a filter of Region on my dashboard and it should automatically show values based on the logged in user.

Please guide me how can we achieve this?

Thanks in advance !

Re: Passing filter values to a Power BI report in Power BI Report Server

gourangib — Wed, 25 Oct 2017 03:31:13 GMT

Please guide me how can we achieve this?

Thanks in advance !

Re: Passing filter values to a Power BI report in Power BI Report Server

vanessafvg — Wed, 25 Oct 2017 15:44:41 GMT

gourangib

you need to set up role based security in SSAS

Re: Passing filter values to a Power BI report in Power BI Report Server

gourangib — Thu, 26 Oct 2017 03:19:27 GMT

vanessafvg

Thank you so much for your kind reply.

Could you pls share some links/articles if you know about SSAS role based security.

Thanks !