Dynamic Date Selection in API

[jitpbi]

Hi,

My report's data source is web where i am getting data using APIs which seems like: 

https://www.xyz.com/api/rest/v1/entries 

In the report, I am using a datetime slicer (slicer type is between)  on a line chart visual. Now, when user select a date range from the slicer then API should pass the parameter for these inputs and give the data accordingly. 

I am struggling to do this, please suggest (step by step) how to do this.

Thanks

[Anonymous]

Hi @lkalawski 
Is this still the case, we have the exact problem

[amitchandak]

@jitpbi , I doubt you can pass parameter from slicer to backend API

refer: https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712

[lkalawski · Accepted solution]

Hi @jitpbi,

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.

Unfortunately, in Power BI for Web connector there is only import mode and schedule refresh options.

More information here:
https://community.powerbi.com/t5/Service/3rd-Party-API-with-Live-connection-refresh-on-each-request/...

_______________
If I helped, please accept the solution and give kudos! 😀