how to show dashboard with filtered result or according to particular user ?

[AnandRanga]

I have data in which there is data related to so many users. I want to create a dashboard using that data and I want to embed that in iframe tag in php.

The thing is that there is a web site, in which user will log in so on the home page there should be data related to only that particular user.

The question is that how can I filter the dashboard according to that particular user ?

The data source from where I am getting the data is MySql server.

Suggest any solution or any helpful links.

Thanks for your time.

[Phil_Seamark · Accepted solution]

Hi there,

Currently you can embed Power BI reports but not dashboards.  You can restrict what different users see using RLS (Row Level Security) which means you can test for the active USERNAME() and decide what they can and cannot see.

I think there are some issues with cross filtering currently when using RLS and Power BI embedded, but I'm sure they'll have it sorted pretty soon.

[v-sihou-msft · Accepted solution]

@AnandRanga

As @Phil_Seamark said, to display the data associated to accessing user, you can use dynamic row level security based on USERNAME(). Please refer to blogs below:

Power BI – Dynamic Row Level Security – Tips to get it working!

Different approach to Dynamic Row Level Security

To achieve RLS via Power BI Embedded, please see: Row level security with Power BI Embedded

Regards,

[Phil_Seamark · Accepted solution]

Hi there,

Currently you can embed Power BI reports but not dashboards.  You can restrict what different users see using RLS (Row Level Security) which means you can test for the active USERNAME() and decide what they can and cannot see.

I think there are some issues with cross filtering currently when using RLS and Power BI embedded, but I'm sure they'll have it sorted pretty soon.