Pull data from rest api with dynamic parameter

Question

Hello,&nbsp;I am trying to get the data from restful api to power bi. This is working.I want to know how can I pass dynamic parameter such as date and department in REST API while pulling data into Power BI.I have filter visualization where I am selecting date and department. I want to use these as parameter.&nbsp;&nbsp;is there any step by step process written.&nbsp;&nbsp;Thanks&nbsp;

lbendlin · Answer

https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/

anonymous · Answer

Thanks&nbsp;lbendlin&nbsp;&nbsp;This is good article to start with.I can use this as reference to select departments but&nbsp;I am curious to&nbsp; know how can I use date as dynamic parameter here.&nbsp;Thanks&nbsp;

lbendlin · Answer

In Power Query find the current date and then use it as a parameter for the API call?

anonymous · Answer

I am gonna use Date dimension dates in Slicer/ Filter Visualization.and that&nbsp; From date and to date will be use for API call&nbsp;Thanks

lbendlin · Answer

The current Power BI design does not support that.

Forum Discussion

Pull data from rest api with dynamic parameter

5 Replies

Related content

Dynamic subcription parameter not saving

Sum dynamic parameter fields multiple selected parameter

dynamic parameter

Dynamic parameter

Dynamic M query parameters