Get Parameterized Query on Report Page

[Anonymous]

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

[v-eqin-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you😀

Best Regards,
Eyelyn Qin

[v-eqin-msft]

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/How-do-I-Call-a-Power-Query-M-Function-from-a-DAX-Measure/m-p/961996#M460925

https://community.powerbi.com/t5/Service/3rd-Party-API-with-Live-connection-refresh-on-each-request/td-p/394315

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.

[amitchandak]

@Anonymous , Not very clear. refer if this can help https://www.thebiccountant.com/2017/03/22/use-slicers-for-query-parameters-in-powerbi/

[Anonymous]

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

[Anonymous]

M Query: