microsoft-bitools.blogspot.com Open in urlscan Pro
2a00:1450:400d:80a::2001  Public Scan

Form analysis
1 forms found in the DOM

https://microsoft-bitools.blogspot.com/search

<form action="https://microsoft-bitools.blogspot.com/search" class="gsc-search-box" target="_top">
  <table cellpadding="0" cellspacing="0" class="gsc-search-box">
    <tbody>
      <tr>
        <td class="gsc-input">
          <input autocomplete="off" class="gsc-input" name="q" size="10" title="search" type="text" value="">
        </td>
        <td class="gsc-search-button">
          <input class="gsc-search-button" title="search" type="submit" value="Search">
        </td>
      </tr>
    </tbody>
  </table>
</form>

Text Content

MICROSOFT BI TOOLS

Blog about Microsoft Business Intelligence: Azure, Power Platform, SQL Server
and related matter





THURSDAY, 23 FEBRUARY 2023


STREAMING DATA AZURE & POWER BI - STREAMING DATASET


Case
I want to send streaming data to Power BI for realtime reporting purposes. This
post is part of a series on Streaming Data in Azure and Power BI. It focusses on
showing the live data in Power BI.

Power BI Streaming dataset
























Solution
In the previous Stream Analytics post we pushed the data from the Event Hub to a
new Streaming dataset in Power BI and in this post we will create a Power BI
report and dashboard to see the streaming data actually moving on our screen.









Posts in this series:
 * Setting up Azure Event Hubs
 * Sending test messages to the Event Hub
 * Setting up hot path in Azure Stream Analytics
 * Setting up cold pathin Azure Stream Analytics *soon
 * Viewing streaming data in Power BI


1) Check dataset
First make sure your Stream Analytics job is running and that data is send to
the Event Hub. Only then a new Power BI Dataset will be created. Note that the
icon for a streaming Dataset differs from a normal dataset. You can edit the
dataset to see which columns are available, but don't change the columns or
settings because Stream Analytics is managing it.

New Streaming dataset in Power BI



























2) Create report
Now create a new Power BI report on the newly created dataset, publish it and 
then view it in Power BI online.

Creating and publish our beautifull report


























The workspace with dataset and report






















The live report

























Now while viewing the report make sure data is still streaming into the Power BI
dataset. You will probably notice that nothing is changing or moving in your
report. Once you hit the refresh visual button you will see the new data.
However continuously hitting the refresh button is not likely an option for you.


3) Pin report visual to Dashboard
Hover your mouse over your report visual and look for the little push pin
button. Click on it to create a new dashboard. Repeat this for all the visuals
you want to see in live mode.

Pin Report Visual to Dashboard


























The workspace with the new dashboard



















Now open the newly created dashboard and watch the data streaming live into your
visuals. You can adjust the size of the visuals to see more details. We left the
bottom right empty to show a PowerShell ISE window pushing data to the Event Hub
and with the lowest and slowest settings (basic Event Hub, 1 streaming unit in
Stream Analytics and the max of 1 message a second) it just takes a view seconds
for the data to appear in Power BI.

Streaming live data into Power BI


























Conclusions
In this post we showed you the end of the hot path by creating a very basic
report and pinning its visuals to a dashboard to see the data streaming live
into your dashboard. You can enrich the dashboard with visuals from your cold
path reports to also compare the live data to for example daily everages. The
storage part of the cold path will be explained in a next post from this series.


Tip: during testing you can empty the streaming dataset by temporary switching
off Historic data analysis in the edit screem of the dataset. You wont see new
data until you switch it on again.





Posted by Joost van Rossum No comments:
Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest
Labels: JOOST, POWER_BI, STREAMING

Older Posts Home

Subscribe to: Posts (Atom)



SEARCH THIS BLOG






AUTHORS

 * Joost van Rossum (130)
 * Ricardo Schuurman (19)
 * Mark de Groot (12)




ARCHIVE

 * ▼  2023 (8)
   * ▼  February (5)
     * Streaming data Azure & Power BI - Streaming dataset
     * Streaming data Azure & Power BI - Stream Analytics
     * Show dataset parameters in Azure Synapse Dataflow
     * Streaming data Azure & Power BI - Event Hubs
     * Streaming data Azure & Power BI - Introduction
   * ►  January (3)

 * ►  2022 (23)
   * ►  December (2)
   * ►  November (2)
   * ►  October (3)
   * ►  September (2)
   * ►  August (1)
   * ►  July (1)
   * ►  June (2)
   * ►  May (3)
   * ►  April (1)
   * ►  March (2)
   * ►  February (3)
   * ►  January (1)

 * ►  2021 (30)
   * ►  December (2)
   * ►  November (6)
   * ►  October (2)
   * ►  September (5)
   * ►  August (1)
   * ►  July (2)
   * ►  June (2)
   * ►  May (1)
   * ►  April (1)
   * ►  March (2)
   * ►  February (3)
   * ►  January (3)

 * ►  2020 (31)
   * ►  December (2)
   * ►  November (2)
   * ►  October (4)
   * ►  September (1)
   * ►  August (1)
   * ►  June (3)
   * ►  May (4)
   * ►  April (3)
   * ►  March (4)
   * ►  February (4)
   * ►  January (3)

 * ►  2019 (18)
   * ►  December (5)
   * ►  November (3)
   * ►  October (2)
   * ►  September (1)
   * ►  August (1)
   * ►  June (1)
   * ►  May (1)
   * ►  March (2)
   * ►  February (1)
   * ►  January (1)

 * ►  2018 (18)
   * ►  December (1)
   * ►  November (1)
   * ►  October (2)
   * ►  September (1)
   * ►  August (2)
   * ►  July (1)
   * ►  June (2)
   * ►  May (1)
   * ►  April (1)
   * ►  March (2)
   * ►  February (2)
   * ►  January (2)

 * ►  2017 (28)
   * ►  December (1)
   * ►  November (3)
   * ►  October (3)
   * ►  September (1)
   * ►  August (2)
   * ►  July (3)
   * ►  June (2)
   * ►  May (2)
   * ►  April (5)
   * ►  March (2)
   * ►  February (2)
   * ►  January (2)

 * ►  2016 (12)
   * ►  December (1)
   * ►  November (3)
   * ►  October (1)
   * ►  September (1)
   * ►  August (1)
   * ►  July (5)




STORIES

 * Publish ADF via DevOps
 * Monitor ADF in Power BI




TOPICS

 * Azure Analysis Services
 * Azure Automation
 * Azure Data Factory
 * Azure DevOps
 * Azure Key Vault
 * Azure Logic Apps
 * Azure Synapse
 * Microsoft Power Apps
 * Microsoft Power Automate
 * Microsoft Power BI




POPULAR POSTS

 * Refresh Power BI Datasets with ADF or Synapse (SP)
 * SSRS Snack: Download all SSRS reports
 * Power Apps: Get next item from gallery
 * Streaming data Azure & Power BI - Stream Analytics
 * ADF Snack: use stored procedure output





Powered by Blogger.



Diese Website verwendet Cookies von Google, um Dienste anzubieten und Zugriffe
zu analysieren. Deine IP-Adresse und dein User-Agent werden zusammen mit
Messwerten zur Leistung und Sicherheit für Google freigegeben. So können
Nutzungsstatistiken generiert, Missbrauchsfälle erkannt und behoben und die
Qualität des Dienstes gewährleistet werden.Weitere InformationenOk