How to: Build a Weather Dashboard with API and Parameters

Hi, just created this dashboard connecting local data and 2 API calls for current weather and 5 days forecast. This is my first public dashboard and tutorial. Hope you enjoy. How to: ...

how to

Technology

cpinho
9 years ago
Hi,

Sure. Here it is.

Let me know.

Best

Carlos Pinho

biitlog.com
ws.pbix9 MB

cferraz_hemav

Helper I

5 years ago

Hi friends!

I'd like to have a report that uses lat and long from one source and uses these parameters to perform one query to the weather provider. In addition the source of lat-long could vary from one week to another so I want this to be dynamic. Is there a way to do this?
Let's say we have this table as an input:

element_id | element_name | long | lat

48087 PORTELLA31086 0.5484911794190 42.2340858391
48088 OBAGA310811 0.5452424355600 42.2364303825
48089 PAUL310812 0.5429963973033 42.2362877305
48090 BOGA Y ROCA310814 0.5564795968214 42.2347207445
48091 MASIA310818 0.5518679290601 42.2373370319

Thanks!

cpinho

Advocate I

5 years ago

If you want to store historical data, than you need to do this outside PBI. You use services as Flow or IFTT (several weather providers are available). You store the data in a excel or txt, and use it as a source to your pbi file too.