Forum Discussion

prashankpm's avatar
prashankpm
Frequent Visitor
4 years ago
Solved

Making dynamic API call using a slicer/filter

Hello, hope you are doing well 🙂   Is there any workaround to make a dynamic API call based on slicer? I know we can make a parameter in Power Query and then bind a field to that parameter and lin...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    That may not be a good user experience.  How often are the gauges read?  You may be better off using  a streaming dataset, a direct query dataset, or even an import mode dataset.

prashankpm's avatar
prashankpm
Frequent Visitor
4 years ago

Thank you very much for your suggestion! I will look into the Power Automate visual. 

Basically, I want to use a web source to import data into power bi for different gauge stations. However, I was thinking if instead of loading data for all the stations (more than 20) I could allow user to select a station name in the slicer and that would alter the API call in the Power Query editor. So every slicer selection by the user will make a new api call to import the data.  

lbendlin's avatar
lbendlin
Super User
4 years ago

That may not be a good user experience.  How often are the gauges read?  You may be better off using  a streaming dataset, a direct query dataset, or even an import mode dataset.