Making a dynamic microsoft power bi report for every user

[Anonymous]

I'm working in a dashboard of KPIs in my angular application using the iframe genarated when publishing the report , well it contains some power bi reports.I want it parametrable with the userId so a personal report is showen for every user .

Any help? and thanks

[v-lid-msft]

Hi @Anonymous ,

If you are looking for showing report with different data for every one, we can use Row-lever security (RLS) to archieve your requirement, please refer to the following documents about how to use this feature:

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

https://docs.microsoft.com/en-us/power-bi/desktop-rls

If you want to show different report page for different user, you can use the pageName parameter, The value provided in the pageName setting corresponds to the end of the report URL when viewing a report in the Power BI Service.

<iframe width="720" height="640" src="https://app.powerbi.com/reportEmbed?reportId=[ReportID]&autoAuth=true&ctid=[ITID]&config=[Config]&pageName=ReportSectionfb03c940d50018e49203&filter=Budget/Brand eq 'Contoso'" frameborder="0" allowFullScreen="true"></iframe>

If it doesn't meet your requirement, could you please provide more details about expected result?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for your help and i tried that but i think this is nor helping.

i will try to clear my question :

 Data are gathered from a SQL Server database.

When a user logs into the web app, I'd like for the queries to update based on that user's ID. So, something like the statement below where the "userid" value dynamically changes.

select * from table where userid = 1234

[v-lid-msft]

Hi @Anonymous ,

We can use the parameter in power query editor, but if you want to get the data based on the user ID, you need to update parameter then refresh the dataset.

The refresh has limition and need time to query again.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for yout solution but i already know it.And i used it for the companies (just 2 companies) but when using it for the users it is not efficiant because you will need to add a filter for every user ( let is say we have 100 one).