Forum Discussion
Dynamic Update of API data with Slicer
Hello Power BI Experts,
I am wondering whether this is possible:
I am able to retrieve some API data say via
You can see above that the weather data can be retrieved INDIVIDUALLY for each country from each API. What I wish to have on the visualization is that we have a Slicer which the user can select one country at a time (Singapore, Malaysia, Thailand), and the plots would be updated accordingly.
Please let me know whether this is possible. If yes, what are the steps.
From my understanding, this is not possible, mainly because each API can only load one set of data based on 1 country. I do not want the case which we combined all that 3 sets of data from those 3 countries. Because those number of countries should be generic, and could be another other countries not listed.
Thanks.
Anonymous , I think is possible only when the Dynamic M parameter is supported. Which I doubt for API -https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#considerations-and-limitations
2 Replies
- amitchandakSuper User
Anonymous , I think is possible only when the Dynamic M parameter is supported. Which I doubt for API -https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#considerations-and-limitations
- AnonymousNot applicable
oh, so it is not possible. Thanks for the confirmation.