Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
obc4758
Frequent Visitor

rp: Parameter in URL does not work

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

 

https://app.powerbi.com/groups/me/reports/23ee0929-ddfa-4f36-a2b7-45a52d433e08/ReportSection?rp:SupC...

 

obc4758_0-1617135238198.png

Yellow should change to two

 

Thanks for your help

 

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
selimovd
Super User
Super User

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.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

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

 

Icey
Community Support
Community Support

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.