{"id":110800,"date":"2017-02-05T01:25:41","date_gmt":"2017-02-05T09:25:41","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/"},"modified":"2017-02-05T01:25:41","modified_gmt":"2017-02-05T09:25:41","slug":"fotw-weather-in-powerbi","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/","title":{"rendered":"Flow of the Week: Show real-time weather data in Power BI"},"content":{"rendered":"

Last week we announced that you could stream data real-time from Microsoft Flow to Power BI. Read Sirui’s full blog post here<\/a> for the announcement and a full walkthrough for gauging Twitter sentiment with Flow and Power BI<\/a>.<\/p>\n

For this week’s Flow of the Week<\/em> we want to highlight another Power BI and Flow streaming scenario brought to us by Kawabata Yoshihiro\u00a0here<\/a>. This flow will populate a tile on a Power BI dashboard showing weather for a location you choose.\u00a0<\/p>\n

Set up the streaming data source<\/h2>\n

If you already use Power BI, sign in, otherwise you can sign up for Power BI for free here<\/a>. Once logged in, select\u00a0Streaming datasets<\/strong>\u00a0in the left navigation inside your workspace:<\/p>\n

\"\"<\/p>\n

Next, you will select\u00a0Add streaming dataset<\/strong>\u00a0in the command bar:<\/p>\n

\"\"<\/p>\n

In the New Streaming Dataset panel select\u00a0API<\/strong>:<\/p>\n

\"\"<\/p>\n

Now you will name your dataset’s values and their type. For this example, you can have fields like\u00a0time<\/em>, temperature<\/em>,\u00a0windspeed <\/em>and humidity<\/em>. For the time field select DateTime <\/strong>and select Number <\/strong>for the other fields:<\/p>\n

\"\"<\/p>\n

Congratulations, you have now set up your streaming dataset that will receive the data from flow!<\/p>\n

Set up your flow<\/h2>\n

You will create a flow from scratch to stream the data. Start by going to your My Flows page<\/a> and selecting Create from Blank<\/strong>.<\/p>\n

The first step in a flow is to add the trigger. This flow will be triggered based on a schedule – for example, every 15 minutes. Select\u00a0Schedule<\/strong>\u00a0in the trigger services and then\u00a0Recurrence:<\/strong><\/p>\n

\"\"<\/strong><\/p>\n

Next, add a step to get the current weather. You can find that step by searching inside of the Choose an action<\/strong> card. Fill in the Location you want weather for and the units you want the data in. The final step in the flow is\u00a0Add rows to a dataset<\/strong>:<\/p>\n

\"\"<\/p>\n

Inside this step you will select your Workspace<\/strong>, Dataset<\/strong>, and then table (which will always be RealTimeData). Pass in the data from the weather step you want to use by selecting Add Dynamic Content<\/strong>. For the time field, you can type in: 20@{utcnow(‘yy-MM-ddTHH:mm:ssK’)} which will populate the time in a format that Power BI expects. Once you have configured the step, create the flow and it will start running.<\/p>\n

Add the tile to your dashboard<\/h2>\n

The part of this tutorial is to add the tile to your dashboard. You can create a new dashboard or use an existing on in Power BI. Select\u00a0Add tile<\/strong>\u00a0in the command bar:<\/p>\n

\"\"<\/p>\n

Select\u00a0Custom Streaming Data<\/strong>\u00a0and then the dataset that you created in the first part of this tutorial. Then, you will configure your tile:<\/p>\n

\"\"<\/p>\n

For the tile, you will select the axis as the time<\/b>\u00a0series, and then display whichever weather measure you want as the values on the chart. You should now be all set, and see data appear on your dashboard in real-time:<\/p>\n

\"\"<\/p>\n

In just a few minutes you have been able to set a new streaming data source for Power BI without writing a single line of code. We recommend also checking out this scenario for streaming Twitter data to a Power BI dashboard<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

See how to use the new integration between Microsoft Flow and Power BI<\/a> to stream data directly into a Power BI dashboard from a flow. In this example we will demonstrate displaying real-time weather data on a Power BI dashboard.<\/p>\n","protected":false},"author":347,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2590],"power-automate-tag":[],"coauthors":[2913],"class_list":["post-110800","power-automate","type-power-automate","status-publish","hentry","power-automate-category-flow-of-the-week"],"yoast_head":"\nFlow of the Week: Show real-time weather data in Power BI - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Flow of the Week: Show real-time weather data in Power BI - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"See how to use the new integration between Microsoft Flow and Power BI to stream data directly into a Power BI dashboard from a flow. In this example we will demonstrate displaying real-time weather data on a Power BI dashboard.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-weather-left-nav.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Stephen Siciliano\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/\",\"name\":\"Flow of the Week: Show real-time weather data in Power BI - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-weather-left-nav.png\",\"datePublished\":\"2017-02-05T09:25:41+00:00\",\"dateModified\":\"2017-02-05T09:25:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-weather-left-nav.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-weather-left-nav.webp\",\"width\":162,\"height\":350,\"caption\":\"graphical user interface, application\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Flow of the Week: Show real-time weather data in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Flow of the Week: Show real-time weather data in Power BI - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/","og_locale":"en_US","og_type":"article","og_title":"Flow of the Week: Show real-time weather data in Power BI - Microsoft Power Platform Blog","og_description":"See how to use the new integration between Microsoft Flow and Power BI to stream data directly into a Power BI dashboard from a flow. In this example we will demonstrate displaying real-time weather data on a Power BI dashboard.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-weather-left-nav.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Stephen Siciliano"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/","name":"Flow of the Week: Show real-time weather data in Power BI - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-weather-left-nav.png","datePublished":"2017-02-05T09:25:41+00:00","dateModified":"2017-02-05T09:25:41+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-weather-left-nav.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw-weather-left-nav.webp","width":162,"height":350,"caption":"graphical user interface, application"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/fotw-weather-in-powerbi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Automate","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/"},{"@type":"ListItem","position":3,"name":"Flow of the Week: Show real-time weather data in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110800"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-automate"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/347"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110800"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110800\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110800"}],"wp:term":[{"taxonomy":"power-automate-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-category?post=110800"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110800"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}