skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Retail
    • For analysts
    • For IT
    • For developers
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
      • Overview
      • Guided learning
      • Documentation
      • Webinars
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign In
    • ·
    • Help
    Go To
    • Galleries
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • MBAS Gallery
    • MBAS Gallery 2020
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • How to: Build a Weather Dashboard with API and Par...
    Accepted Solution

    How to: Build a Weather Dashboard with API and Parameters

    01-18-2017 08:44 AM - last edited 01-18-2017 09:24 AM

    cpinho
    Advocate I
    21852 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    cpinho
    cpinho Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    How to: Build a Weather Dashboard with API and Parameters

    ‎01-18-2017 08:44 AM

    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: Create a Weather Dashboard with Power BI and API

     

    eyJrIjoiMTM1ZTVlNjItNmRiNC00NjQzLTg2NWQtNDM1ZmYwYzM5YTllIiwidCI6ImQ1MWRlNTk2LTQ1YTAtNGFhNS1hMGQ4LTQ3ZDFjOTU4YWEzMiIsImMiOjh9

    Preview file
    139 KB
    Labels:
    • Labels:
    • How To
    • Technology
    Message 1 of 25
    21,852 Views
    5
    Reply
    1 ACCEPTED SOLUTION
    cpinho
    cpinho Advocate I
    Advocate I
    In response to Robbief
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-13-2017 07:12 AM

    Hi,

     

    Sure. Here it is.

     

    Let me know.

     

    Best

    Carlos Pinho

    biitlog.com

    ws.pbix
    Message 12 of 25
    21,330 Views
    2
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    cferraz_hemav
    cferraz_hemav Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎12-07-2020 10:48 AM

    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!

    Message 23 of 25
    390 Views
    0
    Reply
    cpinho
    cpinho Advocate I
    Advocate I
    In response to cferraz_hemav
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎12-08-2020 12:25 AM

    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.

    Message 25 of 25
    348 Views
    0
    Reply
    markive
    markive Advocate II
    Advocate II
    In response to cferraz_hemav
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎12-07-2020 05:14 PM

    Hi @cferraz_hemav ,

     

    I'm not sure you will be able to configure an API request to a weather API to be made dynamically as a Direct Connect datasource in PowerBI.

     

    Therefore the way I would do it is to create a Microsoft Flow or Logic App to loop through your dataset of lat/lng and then get the weather data and save it to a datasource like a Google Sheet or database. Then you will just join this extra datasource into your model. You will also have historical data for all these coordinates. You will just need to make sure yo don't hit API limits.

    Message 24 of 25
    380 Views
    0
    Reply
    cosminc
    cosminc Post Partisan
    Post Partisan
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-24-2018 08:49 AM

    Hi

     

    can you help me please? i'm a little bit stuked

    on the step with the import of api in Power BI i have an issue, please see the attachement.

    it apprears after the step Get Data-Web-and paste the link http://api.openweathermap.org/data/2.5/weather?id=5128581&units=metric&appid={key id}

     

    Thanks a lot!

    Cosmin

    Preview file
    24 KB
    Message 19 of 25
    4,485 Views
    0
    Reply
    cpinho
    cpinho Advocate I
    Advocate I
    In response to cosminc
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-25-2018 04:31 AM

    Hello cosminc

     

    You should chose the web API , so that the key you are parsing on the URL is authentication you are going to use.

     

    Let me know if it helps.

     

    Best

    Carlos

    Message 20 of 25
    4,473 Views
    1
    Reply
    cosminc
    cosminc Post Partisan
    Post Partisan
    In response to cpinho
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-16-2018 05:15 AM

    Hi Carlos

    first of all sorry that i give you feedback so late, i was busy with other projects.

    the API key wasn't put right by me, the support from the site gave me the right syntax.

    now i want to take data - historical (last 2 weeks)+5 day forecast+current day

    do you have any idea how to make import pictures - from what columns and how to to this in power bi

    i want to obtain for last 2 weeks+current day+3 days forecast - a picture for each day with sun/rain like on tv:) and bellow to put daily temperature and precipitations (% form 100% chances) or maybe you have a suggestion

    thanks

    Cosmin

    Message 21 of 25
    4,347 Views
    0
    Reply
    cosminc
    cosminc Post Partisan
    Post Partisan
    In response to cosminc
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-17-2018 08:33 AM

    I found on topic an example and understood how to solve my issues.

    the main issue is that i need historical data last 2 weeks and on openweathermap.com are not free

    Message 22 of 25
    4,333 Views
    0
    Reply
    musicbydannyd
    musicbydannyd Advocate IV
    Advocate IV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎01-18-2017 10:29 AM

    It's pretty humid in NY! 😉

    Message 2 of 25
    21,519 Views
    1
    Reply
    cpinho
    cpinho Advocate I
    Advocate I
    In response to musicbydannyd
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎01-18-2017 04:19 PM

    Indeed! over 100% 😉

     

    Thank you for enjoying.

    Message 3 of 25
    21,503 Views
    0
    Reply
    musicbydannyd
    musicbydannyd Advocate IV
    Advocate IV
    In response to cpinho
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎01-19-2017 06:35 AM

    Would you be interested in swapping one of my weather .pbix file (using wunderground.com) for yours?

    Message 4 of 25
    21,487 Views
    0
    Reply
    musicbydannyd
    musicbydannyd Advocate IV
    Advocate IV
    In response to musicbydannyd
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎01-19-2017 02:42 PM

    Your blog is restricted at my company, so I'm posting my weather query file here for all to enjoy! 🙂 Sorry for the extra (bonus?) tables as this was a part of a golf rounds report.

     

    To use weather in your area (I beleive it's US only), replace 'KGAEATON6' in the query text with the station ID from your local station... find it at www.wunderground.com (I beleive it's US only) by typing in your city/state or zip code.

    wunderground query.pbix
    Message 5 of 25
    21,478 Views
    1
    Reply
    cpinho
    cpinho Advocate I
    Advocate I
    In response to musicbydannyd
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎01-24-2017 01:32 AM

    Hi 

     

    I've sent you via email the pbix file. Hope it helps. In the meantime, checking your file. It seems is returning some errors. Believe is due to relationships. Although hadn't yet time to check it closely. Will get back to you ASAP.

     

    Best

    Carlos

    Message 6 of 25
    21,450 Views
    0
    Reply
    asanghi
    asanghi
    Regular Visitor
    In response to cpinho
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-05-2017 03:32 PM

    Whenever I enter the data source (e.g., http://api.openweathermap.org/data/2.5/forecast/city?id=4922388&APPID={xyz}) I get a prompt with 'Access web content The user was not authorized'? Do you know why? I entered my api key correctly. Screenshot attached. 

    Preview file
    29 KB
    Message 9 of 25
    21,276 Views
    1
    Reply
    cpinho
    cpinho Advocate I
    Advocate I
    In response to asanghi
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-06-2017 06:13 AM

    Hi asanghi,

     

    can you publish you pbix file pls?

    Message 10 of 25
    21,268 Views
    0
    Reply
    Robbief
    Robbief Advocate I
    Advocate I
    In response to cpinho
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-13-2017 04:24 AM

    Could you Publish the PBIX file for us to re-use?

    Message 11 of 25
    5,188 Views
    0
    Reply
    cpinho
    cpinho Advocate I
    Advocate I
    In response to Robbief
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-13-2017 07:12 AM

    Hi,

     

    Sure. Here it is.

     

    Let me know.

     

    Best

    Carlos Pinho

    biitlog.com

    ws.pbix
    Message 12 of 25
    21,331 Views
    2
    Reply
    karinaruess
    karinaruess
    New Member
    In response to cpinho
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎02-27-2020 01:35 PM

    Hey, do you hace the city list ?

     

    Im trying to build the dashboard for my country but the city list isnt available anymore, it would help me alot if you still have the complete city list!

     

    thanks

    Message 17 of 25
    604 Views
    0
    Reply
    cpinho
    cpinho Advocate I
    Advocate I
    In response to karinaruess
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎02-27-2020 11:52 PM

    Hi

     

    I guess the URL has changed, but it still accessible. Please go to http://bulk.openweathermap.org/sample/ and choose the citylist JSON archive. 

     

    Hope it helps.

     

    Best

    Carlos

    Message 18 of 25
    587 Views
    0
    Reply
    cosminc
    cosminc Post Partisan
    Post Partisan
    In response to cpinho
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-21-2018 09:47 AM

    Hi,

    did you how to store the weather data and to create a historical base?

    Many thanks,

    Cosmin

     

    Message 16 of 25
    4,297 Views
    0
    Reply
    payal4
    payal4 Helper III
    Helper III
    In response to cpinho
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-03-2018 03:47 AM

    Hello Carlos Pinho,

     

    After changing the data source as API source, I'am getting an error "We couldnt authenticate with the credentials provided".

    I have changed the privacy settings also for the current file.

    Please help

    Message 15 of 25
    4,425 Views
    0
    Reply
    Preview Exit Preview

    never-displayed

    You must be signed in to add attachments

    never-displayed

    Additional options
    You do not have permission to remove this product association.
     

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    • © 2021 Microsoft
    • Follow Power BI
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks