Forum Discussion
Making dynamic API call using a slicer/filter
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.
Emulate the slicer with a Power Automate visual. The problem will be that this visual can then not influence the rest of the data model.
Describe what you are trying to achieve.
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.
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.