Forum Discussion
Dynamic Date Selection in API
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
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/td-p/394315
_______________
If I helped, please accept the solution and give kudos! 😀
3 Replies
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/td-p/394315
_______________
If I helped, please accept the solution and give kudos! 😀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
Hi lkalawski
Is this still the case, we have the exact problem
