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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
athhar
Frequent Visitor

Change report parameter using URL

Hello experts,

 

I have a working set up of parameter pOwner and use it to filter the query. Next step is to let user change the parameter value through URL query (https://app.powerbi.com/.../ReportSection?rp:pOwner=amy). Found this article but doesn't seem to work: https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-url-pass-parameters

Any idea?

 

let
Source = Sql.Database("someserver.database.windows.net", "somedatabase", [Query="select * from items where belongs_to='" & pOwner & "'"])
in
Source

4 REPLIES 4
aribanMSFT
Employee
Employee

Im struggling with the same issue. How can a powerBI report viewer edit the parameters ? PowerBI seems ti have been built with novice developers and product managers seriously. Sad but its the truth

lbendlin
Super User
Super User

regular reports don't have parameters (data sources have parameters). You can specify report filters, and bookmarks.

lbendlin
Super User
Super User

i think you are mixing paginated reports with regular reports in the Power BI service. They likely use different URL schemas.

Yes so I learned. Also means there is no way for regular report to change its parameters?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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