Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Dear All,
I have a report with a parameter. If I change the value in the parameter area manually everything works fine as it should. However I want to transfer the value in the url. In this case it shows no influance. What do I make wrong?
This is my setup:
let
Quelle = Sql.Database("Momo", "WorkCollaboration", [Query="exec WorkCollaboration.dbo.SelectPersonalTimeReport @SupContactIdParam = 1"]),
#"Umbenannte Spalten" = Table.RenameColumns(Quelle,{{"TimeReportSupContactPointValue", "Point Value"}})
in
let
query_SP =
"exec WorkCollaboration.dbo.SelectPersonalTimeReport @SupContactIdParam = "
& Text.From(SupContactIdBiParam),
#"Umbenannte Spalten" = Table.RenameColumns(Quelle,{{"TimeReportSupContactPointValue", "Point Value"}}),
Source =
Sql.Database(
"Momo",
"WorkCollaboration",
[Query = query_SP]
)
in
Source
my URL looks like this
WorkCollaborationTimeSheetPersonal – Power BI
Yellow should change to two
Thanks for your help
Solved! Go to Solution.
Hi @obc4758 ,
It is suggested to configure Row Level Security. Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles.
Reference:
Row-level security (RLS) with Power BI - Power BI | Microsoft Docs;
What is Row-Level Security (RLS) in Power BI??? - YouTube;
Row Level Security Configuration in Power BI Desktop - RADACAD;
What Do You Need to Implement Dynamic Row-Level Security in Power BI? - RADACAD.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @obc4758 ,
as far as I know you have to use "filter" as parameter and then enter with "eq". See the documentation:
Filter a report using query string parameters in the URL - Power BI | Microsoft Docs
So your example would look like this:
https://app.powerbi.com/groups/me/reports/23ee0929-ddfa-4f36-a2b7-45a52d433e08/ReportSection?filter=SupContactIdBiParam eq 2
or to replace the space with "%20":
https://app.powerbi.com/groups/me/reports/23ee0929-ddfa-4f36-a2b7-45a52d433e08/ReportSection?filter=SupContactIdBiParam%20eq%202
Check if that works. If 2 is a string you have to put single quotes, see the documentation for more information.
Dear Denis, thanks for helping. Does it mean that I need all data in oder to apply the filter. Because I want to prevent that a user can see data from someone else. Thats why I was working with the parameter as a where clause. So only data of specific user get loaded.
Is it not possible to update with the url parameter rp: the given parameter in the used where clause as it works when I change my paratemeter value in the parameter setup? Or is the filter only loading the needed data from data base?
Thanks for your support
Christof
Hi @obc4758 ,
It is suggested to configure Row Level Security. Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles.
Reference:
Row-level security (RLS) with Power BI - Power BI | Microsoft Docs;
What is Row-Level Security (RLS) in Power BI??? - YouTube;
Row Level Security Configuration in Power BI Desktop - RADACAD;
What Do You Need to Implement Dynamic Row-Level Security in Power BI? - RADACAD.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |