topic Re: Change report parameter using URL in Developer

Change report parameter using URL

athhar — Mon, 04 Jan 2021 04:57:14 GMT

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

Re: Change report parameter using URL

lbendlin — Mon, 04 Jan 2021 22:16:16 GMT

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

Re: Change report parameter using URL

athhar — Tue, 05 Jan 2021 03:07:32 GMT

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

Re: Change report parameter using URL

lbendlin — Tue, 05 Jan 2021 03:13:58 GMT

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

Re: Change report parameter using URL

Anonymous — Mon, 17 Oct 2022 19:15:38 GMT

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