Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

 

https://weather.visualcrossing.com/VisualCrossingWebServices/rest/services/timeline/Singapore?unitGroup=metric&contentType=json


https://weather.visualcrossing.com/VisualCrossingWebServices/rest/services/timeline/Malaysia?unitGroup=metric&contentType=json

 

https://weather.visualcrossing.com/VisualCrossingWebServices/rest/services/timeline/Thailand?unitGroup=metric&contentType=json

 

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

  • 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

    • Anonymous's avatar
      Anonymous
      Not applicable

      oh, so it is not possible. Thanks for the confirmation.