en da en de da da de es sv da en en da it da en de da da es da en da en en en da pt fr fr de sv da da sv da en en en en en en en en en en en en en en en en en en en en en da da da sv de da en en en en en en en da en en nl nl da en da de de en en nl en en nl nl sv en da de de en en nl en en nl nl sv en da de de en en nl en en sv nl da en da de da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en en da ms en en en da sv fr da da it en id en da de da en en en en da en ro da da en da nn da ar bg ca hbs_lat da de de de el de en en tr en en en en en en en es es et eu fi fr fr fr fr lt he hi hbs_lat hu id it it ja ko kk lt lv ms da nl nl pl pt pt ro ru sk sl hbs_lat hbs_lat sv th tr fy vi zh zh
Flow of te Week: Show real-time weather data in Power BI | Power Automate Blog
Emner om automatisering af forretningsproces og arbejdsgang
Stephen Siciliano, Partner PM Director, Power Automate, 5. februar 2017
Last week we announced that you could stream data real-time from Microsoft Flow to Power BI. Read Sirui's full blog post here for te announcement and a full walkthrough for gauging Twitter sentiment with Flow and Power BI.
For this week's Flow of te Week we want to highlight another Power BI and Flow streaming scenario brought to us by Kawabata Yoshihiro here. This flow will populate a tile on a Power BI dashboard showing weather for a location you choose.
Set up te streaming data source
If you already use Power BI, sign in, otherwise you can sign up for Power BI for free here. Once logged in, select Streaming datasets in te left navigation inside your workspace:
Next, you will select Add streaming dataset in te command bar:
In te New Streaming Dataset panel select API:
Now you will name your dataset's values and their type. For this example, you can have fields like time, temperature, windspeed and humidity. For te time field select DateTime and select Number for te other fields:
Congratulations, you have now set up your streaming dataset that will receive te data from flow!
Set up your flow
You will create a flow from scratch to stream te data. Start by going to your My Flows page and selecting Create from Blank.
Te first step in a flow is to add te trigger. This flow will be triggered based on a schedule – for example, every 15 minutes. Select Schedule in te trigger services and then Recurrence:
Next, add a step to get te current weather. You can find that step by searching inside of te Choose an action card. Fill in te Location you want weather for and te units you want te data in. Te final step in te flow is Add rows to a dataset:
Inside this step you will select your Workspace, Dataset, and then table (which will always be RealTimeData). Pass in te data from te weather step you want to use by selecting Add Dynamic Content. For te time field, you can type in: 20@{utcnow('yy-MM-ddTHH:mm:ssK')} which will populate te time in a format that Power BI expects. Once you have configured te step, create te flow and it will start running.
Add te tile to your dashboard
Te part of this tutorial is to add te tile to your dashboard. You can create a new dashboard or use an existing on in Power BI. Select Add tile in te command bar:
Select Custom Streaming Data and then te dataset that you created in te first part of this tutorial. Then, you will configure your tile:
For te tile, you will select te axis as te time series, and then display whichever weather measure you want as te values on te chart. You should now be all set, and see data appear on your dashboard in real-time:
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.
Hvad er Power Automate?
Power Automate er en tjeneste til at automatisere arbejdsgangen på tværs af et voksende antal apps og SaaS-tjenester, som virksomhedsbrugere er afhængige af.
Få mere at vide
Flow of te Week
Beskyttelse af personlige oplysninger og cookies