skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Partners Overview
    • Solutions Partners
    • BI Specialized Partners
    • Power BI CSOs
    • Fabric Partner Community
    • Training
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power BI forums
    • Updates
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish forums
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    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: 

    Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

    • Power BI forums
    • Galleries
    • Data Stories Gallery
    • Re: How to: Build a Weather Dashboard with API and...
    Accepted Solution

    Re: How to: Build a Weather Dashboard with API and Parameters

    05-16-2018 05:15 AM

    cosminc
    Post Partisan
    14977 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
    • 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 26
    32,907 Views
    6
    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
    • 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 26
    32,373 Views
    2
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    Rebel
    Rebel
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-09-2023 03:11 AM

    Hi Carlos 
    Your tutorial link isn't working can you please upoad the correct link.
    Thank you 
    Rebel

     

    Message 26 of 26
    1,213 Views
    0
    Reply
    cferraz_hemav
    cferraz_hemav Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 26
    11,016 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
    • 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 26
    10,974 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
    • 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 26
    11,006 Views
    0
    Reply
    cosminc
    cosminc Post Partisan
    Post Partisan
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 26
    15,115 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
    • 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 26
    15,103 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
    • 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 26
    14,977 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
    • 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 26
    14,959 Views
    0
    Reply
    musicbydannyd
    musicbydannyd Advocate IV
    Advocate IV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎01-18-2017 10:29 AM

    It's pretty humid in NY! 😉

    Message 2 of 26
    32,162 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
    • Report Inappropriate Content

    ‎01-18-2017 04:19 PM

    Indeed! over 100% 😉

     

    Thank you for enjoying.

    Message 3 of 26
    32,146 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
    • 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 26
    32,130 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
    • 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 26
    32,121 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
    • 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 26
    32,093 Views
    0
    Reply
    asanghi
    asanghi
    Regular Visitor
    In response to cpinho
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 26
    31,919 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
    • Report Inappropriate Content

    ‎03-06-2017 06:13 AM

    Hi asanghi,

     

    can you publish you pbix file pls?

    Message 10 of 26
    31,911 Views
    0
    Reply
    Robbief
    Robbief Helper II
    Helper II
    In response to cpinho
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-13-2017 04:24 AM

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

    Message 11 of 26
    15,819 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
    • 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 26
    32,374 Views
    2
    Reply
    karinaruess
    karinaruess
    New Member
    In response to cpinho
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 26
    11,235 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
    • 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 26
    11,218 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
    • 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 26
    14,927 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • 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

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices