how to pass dynamic Query Paramters using REST API to JSON as data source

[Anonymous]

Hi Experts

I'm accessing the REST API URL as a direct query data source through the CData Power BI Connector for REST but the current URL has a hard coded value but how could I pass parameter dynamically in the power bi.

I have created 2 columns in the schema (JSON) which can be used as a parameter- pease see the below

<input name="effectiveDate" required="true"/>
<input name="prodId" required="true"/>

and change the URL to http://hotsname/sources/DimSales?rs:effectiveDate=[_input.effectiveDate]&rs:prodId=[_input.prodId]&r...

And also created Parameters in the Power BI with the same names (effectiveDate, ProdId) and assigned these to Query dataset in the M Query but got the below error.

[Icey]

Hi @Anonymous ,

Hope these documents can help you:

Parameters for JSON API data - Maintain Query daily;

Dynamic connection to Web URL.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.