CODEWITHSUNDEEP
powerbipowerquerypowerbi-desktop
amokrane oulmi
amokrane oulmi

Reputation: 53

filter a power bi report according to the value of a parameter

is it possible to filter a report according to the value of a parameter.

let me explain:

I have a report that shows me the sales, turnover... from several agencies (6000), I would like each agency director to have access to just the appalling information about his agency, I thought I forced each user to enter the code of his agency when he wants to access the report and the report will automatically filter itself and display only the information that corresponds to that agency.

I don't know if it's possible to do this with Power BI or how to do it.

Upvotes: 0

Views: 91

Answers (1)

mxix
mxix

Reputation: 3659

Since you will publish your report to Power BI Report Server, you have two approaches using Row Level Security.

You can go for a more Static approach, setup one Role for each agency, and filter your agency table.

Or you can create a table that maps users to agencies, and use the USERNAME(), dax function to filter your data.

Power BI Report Server - Row Level Security

Upvotes: 1

Related Questions