PowerBI for real-time dashboard

-

 


You might already be using Power BI to create your dashboards and reports, but have you tried to create a real-time dashboard before? Typically, you need to set up a refresh schedule. What if you want to see your dashboard update live, as soon as fresh data comes in? This is where you can use a streaming dataset in Power BI, to view and act on your data in real-time.

Here are some examples of times you could consider using a real-time dashboard:

  • IoT devices: sensors, machinery. Anything with a constant flow of data you would like to view accurate information on. This is a great option for being able to detect anomalies in equipment.
  • Collecting survey responses and viewing feedback immediately
  • Viewing weblogs
  • Inventory Management: monitoring stock levels

Streaming datasets can be created from Power BI Service. When heading over to Power BI Service to create your streaming dataset, you have 3 types to choose from.

The API option is the most accessible for anyone to get started with. Using the API option creates a “Push Dataset”, i.e. the Power BI API takes your data and pushes it into a dataset for you. You can use tools such as Power Automate or PowerShell to add rows into your table. When this happens, your dashboard tiles update automatically with the new data. The benefit of using a push dataset is that data is getting stored in a database in Power BI Service. You can do historical analysis- go back in any point in time and see what occurred. In addition, you also get the full report building features too, like all the visuals and creation of measures.

Azure Stream and PubNub require you to have access to these services and are ideal for IoT use cases. They allow you to rapidly output your data stream to Power BI. If you are currently using Azure Stream Analytics (e.g. such as for monitoring sensors), you can link it up your jobs to Power BI so that you can visualise current levels and trends as they come through in Azure Stream.

Reach out to Prometix if you’re interested in seeing how we can assist you with Power BI and real-time streaming. If you’re looking to upskill your teams on Power BI or the rest of the Power Platform, we can also run training in-house for you.

Prometix as a Microsoft Gold certified partner and certified O365 consultants (Sydney, Canberra, Melbourne & Perth), we have extensive experience in delivering Office 365 based solutions. For more information, please contact us from enquiries@prometix.com.au

 

Comments

Post a Comment

Popular posts from this blog

Microsoft 365 Records Management Compliance

-
As a SharePoint consulting practice, we at Prometix had a chance to implement a Microsoft 365 Records Management service This is a fairly new service and Microsoft announced in May the commercial release of the Microsoft 365 Records Management service. This service, which lets organisations apply "labels" to documents, as well as machine learning to automatically apply those labels, is designed to address legal compliance tracking issues for organisations. Microsoft claims it'll help demonstrate compliance with regulations through defensible audit trails and proof of destruction. This will assist in integrating with Business Intelligence such PowerBI, and artificial intelligence such as Azure services. The Records Management service is currently available through the  Microsoft 365 Compliance Center . Organisations need to have Microsoft 365 E5/A5 or Microsoft 365 Insider Risk Management licenses to use the service, which gives them the rights to automatically apply ...
Read more

Collaboration with SharePoint VS MS Teams

-
With all the hustle and bustle of the workplace, it can be hard to find exactly what you’re looking for or know who to ask. Defining who is working on what and how they’re involved in the project isn’t always a simple task. Although SharePoint has made managing and sharing content easier, it still isn’t as seamless as its end users would hope. Being able to access content and applications all in one place is useful but doesn’t solve the problem of how to organize information that is only relevant to certain groups. The main goal of SharePoint is to facilitate collaboration, but when content is broadcasted to the entire organization, it can make end users unsure which information applies to them. Microsoft has acknowledged this issue with the creation of its new collaboration tools, SharePoint team sites and Microsoft Teams . These allow end users to create separate areas specifically designed for certain projects they’re working on and for the teams they’re working with. By organizi...
Read more

Data Governance with Azure Purview

-
Image
The modern workplace his a data-centric world. Organisations are always increasing the amount of data they must collect, store, and analyse to inform critical business decisions and measure their organisation’s performance. As data becomes increasingly important, so do the tools needed to discover, manage, and track information in the absence of a data governance program. In the absence of a data governance program, the decisions made about key data systems are made by association staff who “own” the system. When there are different owners for systems (which is very common), the result is inconsistencies in data availability, collection, usability, integrity, and security. This instantly causes data quality problems. It also can negatively impact user experience if there is no integration or procedures to update the existing data within your environment. If you and your organisation find yourselves in such a predicament, Prometix highly recommends deploying an Azure Purview solution....
Read more