Forum Discussion

bishnu's avatar
bishnu
Helper II
6 years ago
Solved

Real time weather data with Powerbi using Flow

Hello

I have been trying to create real time weather data. Intially i tried with PubNUb. Though i succeded i couldnt set location. 

Now i am tring using Flow

https://flow.microsoft.com/en-us/blog/fotw-weather-in-powerbi/

Step 1) Set up your flow

Step 2)  Add the tile to your dashboard

 

 in step 1, I created flow, but i didnt understand the following step

Can anybody expian we what is this step?

 

Regards

BB

  • Use 'Get currect weather' instead of 'Get forecast for today'. I think you need current weather, not forecast.

6 Replies

  • avatorl's avatar
    avatorl
    Impactful Individual

    bishnu
    On your previous step you already created a streaming dataset (it's like a table with, for example, 'Date Time', 'Temperature' and 'Wind Speed' fields).

     

    Now, in the Flow, you need to select your workspace, dataset name and table name (table name is 'RealTimeData' always). Once you selected the above you'll see a list of your streaming dataset table fields (created in Power BI Service).

    You need to put cursor into each of the fields and assign 'dynamic content' to this field. Dynamic content is what your data connector provides (in your case 'Get current weather' connector provides different weather related variables).

    For example, put cursor into the Temperature field and you see pop up window with a list of dynamic content provided by 'Get current weather' connector, find Temperature variable and click on it to add to the field:

    It's just to match your dataset fields with data fields provided by the weather connector.

    Once you are aware with the list of available weather variables you can go back to Power BI and add additional fields to the data set.

    For example, add 'Dewpoint' field to the data set (there is a typo in my field name, it's not a problem because you're going to match Dewpoint variable with Devpoint field manually):

     

    Go back to Flow, reload your flow and you'll see your new Devpoint field:

     

    • bishnu's avatar
      bishnu
      Helper II

      Hello avatorl 

      Thanks a lot. it was helpfull. I followed all your steps

      1)Defined streaming API data in powerbi

      2)Defined flow

      3)Defined new tile

      But unfortunately my dashboard  is empty, i dont see any data

       

      Why is it so, am i doing something wrong?

       

      Thanks 

       

      BB

      • avatorl's avatar
        avatorl
        Impactful Individual

        I assume your flow is running with no errors, right?

        1) You see this? It means "show only last 1 minute on a graph", but you're refreshing your data one per minute. Increase 'time window to display' to last for example 10-15 minutes.


        2) Also you used 'Forecat Date' variable. Probably it returns just a date instead of date-time.
        Use 'Last Updated' variable for your Time field.