Forum Discussion
Power BI - Filter based on user accessing the dahsboard? (SSAS Tabular)
Hi, hopefully someone can help me with this. I have a dashboard that uses an SSAS tabular model as a data source. The main filter on the dashboard is a Username filter.
Is it possible for me to dynamically filter this based on who is viewing the dashboard? I.e. if John.Malone views the report, the filter will automatically show data for John.Malone.
Can this be done and if so what is the best way to do it?
Many thanks!
Hi Anonymous ,
If your connection type is "Import", you can apply RLS in Power BI Desktop.
If your connection type is "Connect Live", you will not be able to configure RLS within the Power BI service. This is defined within the Analysis Services model on-premises. You can refer to this article to implement RLS in an Analysis Services Tabular Model and use it in a Power BI report.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- Icey
Community Support
Hi Anonymous ,
If your connection type is "Import", you can apply RLS in Power BI Desktop.
If your connection type is "Connect Live", you will not be able to configure RLS within the Power BI service. This is defined within the Analysis Services model on-premises. You can refer to this article to implement RLS in an Analysis Services Tabular Model and use it in a Power BI report.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.