Forum Discussion

cosminc's avatar
cosminc
Icon for Post Partisan rankPost Partisan
8 years ago

add weather web page

Hi all,   I need to import in PBI a weather page, something like this https://weather.com/weather/monthly/l/ROXX0003:1:RO or maybe you have something better or which it works fine. i need to see t...
Need Help
cosminc's avatar
cosminc
Icon for Post Partisan rankPost Partisan
8 years ago

Yep

with degrees Celsius also

for next days vs same days from previous week

and refreshable (dinamycs when i reload the data)

help me please to obtain it in PBI Desktop

 

Many thanks for your effort!

Cosmin

ask4atish's avatar
ask4atish
Icon for Advocate III rankAdvocate III
8 years ago

I clicked on get data and chose web option from dropdown and here I used https://weather.com/weather/5day/l/ROXX0003:1:RO You can use your own website info here from where you want to fetch data.

 

Then there were two datasets to choose from. First one was document which didn't consist the required data. I chose "table 0" as I saw in preview that it contains data for today and predictions of next coming days. clik ok and then you would see your data under data pane. Here you need to modify the column names. Finally now data is in your powerBI desktop. Now you can use you own visual to represent how you want to show it.