How to let end users change the parameter that is passed to the powerBi report on report server?

[Anonymous]

Is it possible to allow end-users to change the parameters on power bi report on the report server?

Want the end users to be able to change the @StartDate @EndDate parameters for the SQL stored procedure

Thanks

[ArnieWolff]

This likely isn't accessible for the end user, but you can change the parameters on a report that you've published. In the Workspace under Datasets, you can see and change parameters you've created. Here's a sample of how it looks on my workspace.

[mjc543]

Check out this article:

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/power-bi/end-user-editing-que...

[d_gosbell · Accepted solution]

You can currently only pass parameters to stored procedures if you are using paginated reports.

If you are using a pbix based report that imports the data then the only way to edit parameters like these is to open the report in Power BI Desktop, change the parameter and then re-publish the report (which then changes these values for everyone running this report) . There is no way of changing parameters in your M script from Report Server.

[MilesDS]

This seems crazy?  I'm new to power bi & I have calculations based off a user selection (parameter).  I'm using a data source that has a mixed bag of currencies & based off what parameter is selected the calculation updates the currency value/amount.  Is there a way to accoplish this (parameter or something else)?  The user will be using the cloud based Power BI.

I'd rather not turn this into a filter by having my query 1 convert to accomidate for every currency & then stack the data 6 times so that the currency code can be filtered without data loss.

Thank you for any help & coming back to this post.

[d_gosbell]

---

@MilesDS wrote:

The user will be using the cloud based Power BI.

The you might be able to use the Dynamic M parameters feature https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters This forum and the answer above specifically relate to the on-prem Report Server product which has a number of limitations when compared to the cloud service.

But if your data source does not support dynamic M parameters then there is nothing wrong with bringing all the data into your tabular model and doing the calculations there. It will probably take longer for the model to refresh, but you will get faster report performance.