Forum Discussion

obertimanuel's avatar
obertimanuel
Frequent Visitor
2 years ago
Solved

Weather data

Hello everyone, I would like to create a chart displaying weather data extrapolated from api https://api.met.no/weatherapi/locationf ... =60&lon=11 And so far so good , as long as it is fixed lat ...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    My query is just a sample as I don't have all your  lat and long combinations. Create a custom column and paste that formula in the custom column step from the code I gave you which is a modified version of your code. Reference these two to the actual column names:

       Latitude =  [Lat Column],
   Longitude = [Lon Column],

obertimanuel's avatar
obertimanuel
Frequent Visitor
2 years ago

Thanks I tried this solution too...... but I have about 150000 cities and its not possibile

 

tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

obertimanuel 

Okay, Since you data source is an API, you cannot convert the storage mode to direct query mode and you cannot leverage dynamic m query parameters.

 

There is one option which I think might work in your case, that is you can use paginated reports and leverage Power query 'get data' experience. This is a new option released by Microsoft recently. You can find more information here: https://www.youtube.com/watch?v=OQKgnJkjJDI

 

And, if you want you can also embed this paginated report in a power bi dashboard.

 



Need Power BI consultation, hire me on UpWork .


If the post helps please give a thumbs up



If it solves your issue, please accept it as the solution to help the other members find it more quickly.




Tharun