Forum Discussion
Get Parameterized Query on Report Page
Hi Experts,
Need a help!
I am trying to create a report where data is populating via hitting an API ( contains JSON data). Now, defining a parameterised query on Power Query, so user can input the search results and retrieve live data from API.
Need that defined query on Report level, as a search so users can enter the data directly everytime and as a result, a tbale shows the data fetching from API ( in backend).
How to get the parameterised query on report level, please share your inputs.
Any help would be appreciated!
Regards,
Anjali
5 Replies
Hi Anonymous ,
From what I understand you want to connect to the API and every time the user changes the value of the slicer a request will be sent to the API to return new data.
Please check if these could help you a little:
Power BI - Passing Slicer Selections into a SQL Query (Animated X-Axis) - YouTube
https://community.powerbi.com/t5/Desktop/Slicer-Value-as-a-parameter-to-stored-procedure/m-p/220397
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Anonymous , Not very clear. refer if this can help https://www.thebiccountant.com/2017/03/22/use-slicers-for-query-parameters-in-powerbi/
Hi Amit,
Thanks for your response! Let me add a bit more details.
We are trying to develop a report in Power BI where the requirement is to pull data hitting a REST API ( all logic resides at API end).
To present it as a report , we wrote M query as shown in the screenshot and defined a parameter to input the values.Parameter: "Apple" meta [IsParameterQuery=true, Type="Any", IsParameterQueryRequired=true]
Whatever we input in the parameter , it should hit the API and get you the data ( and we achieved it in power query).
The challenge is we need this parameter on Report Page so users can pass the values ( as a search box) and get the result values in any form of visual.
We want to achieve it and open for suggestions. Any help would be much appreciated!Regards,
Anjali Rai
