Dynamic Parameters in the Report Server URL

amybirc77 — Tue, 10 Jan 2023 17:00:08 GMT

Hi All,

I have created a dashboard using Desktop RS Version. I have deployed it to our report server

http://pwrbi.corp.mycompany.com/ReportsProd/powerbi/Application%20Dashboards/riglevelreport

This Dashboard has 10 pages (tabs). There are 45 different end users , but the dashboard is the exact same one. This dashboard is embedded into an application. So if USER1 Clicks on the link that person must see data pertaining to RIG1

USER2>RIG2

USER3>RIG3

..... USER45>RIG45

I looked up some links, but each one is manual like this one

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables?tabs=powerbi-desktop

Is there a dynamic way of doing this?

Thanks

Re: Dynamic Parameters in the Report Server URL

d_gosbell — Wed, 11 Jan 2023 22:06:17 GMT

If this is a security requirement (as in User1 should only be able to see RIG1 and no other values) then you could implement row level security Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

There is a technique often called "Dynamic Row level security" where you create a table in your mode that has a mapping of the usernames to the values they are allowed to see. This article Dynamic Row Level Security with Power BI Made Simple - RADACAD explains how this can be set up.

topic Re: Dynamic Parameters in the Report Server URL in Report Server

Dynamic Parameters in the Report Server URL

Re: Dynamic Parameters in the Report Server URL