Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to pass dynamic parameter to the JSON as a data source

Hi,   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 dynamicall...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-juanli-msft , Thanks for your inputs, 

 

With the Power BI Service URL query string parameters will filter the report, but they will not change report parameter values, i.e. it will not re-execute the data source with the values passed in the URL.

 

Plese see the below an overview of my target.

I'm using the Datasource : REST API i.e http://ABC/datasources/Products?rs:Date=2020-01-02 and its running fine and getting data as i am passing all parameters dynamically but It is not pulling the data by changing the URL parameter once I Published the Report to Power BI Service .

 

I'm not sure whether, this can be achieved as of my knowledge Power BI Query string parameters are for filtering the data and it will not re execute the datasource to get new data.