Forum Discussion
Dynamically control the Rest API URL for datasource "from Web" based on user input/interaction
Hi Panto ,
Do you want to use filters or slicers to set the value(s) for an query parameter? You can refer to the preview function: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters.
Since it is a preview version, so it has many limitations and may not have good technical support.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Panto ,
You can create a parameter first(I have will show the steps by my test api):
Then you can use parameter for getting data from web:
After publishing the report to the power bi service , you can change the parameter in :
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Dedmon,
the solution I am looking for is soemthing that allows the final user of the report (may be someone with basic and non-admin profile) to dynamically change the value of that sepcific paremeter (can be more than one) only within the report published on PBI service.
So basically, he/she opens the report with a "default value" retrieved from the REST API, and then without anything else but the report itself, he/she has "something" to click on / interact with in order to change that parameter and retrieve new data.
Best
Fabio