Change report parameter using URL

[athhar]

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

[aribanMSFT]

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]

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

[lbendlin]

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

[athhar]

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