Hello!! We are back once again with another exciting blog on the features of Microsoft Power BI, basically we are going to explore the Streaming Datasets or Real time data through PubNub in Power BI application. So, let’s move to the point and start exploring Real Time data with Power BI.
When we open the Power BI application, navigate to the Datasets portion and click on Streaming Dataset option.
After clicking on it, a new page will open up that contains all your streaming data sets that are created up till now. To create a new one, click on the Add Streaming Data set located on top right of your screen.
A new dialog will open up that’ll give the options of creating the dataset through an API or PubNub, we’re going to use PubNub Data source for this demo, so select it and hit next
You’ll be asked to give information about the sort of data that you want to fetch,
Dataset Name: Any meaningful name.
Sub-key: Provided by PubNub.
Channel Name: Domain of data that you want to access.
After your Data stream is accessed, it will give the option to select the values that are only relevant to you, in my case, I am going to fetch all the default values. After that, click on the Create button and it will start creating the Data stream.
Once done, it will notify that the dataset is created and can be used now.
It will also be included in your Streaming Data sets list.
Now, let’s create a new Dashboard for adding visuals to analyze our Live data.
After creating the dashboard, click on the Add Tile option to start adding tiles to your dashboard.
Select Custom Streaming Data option from the Add Tile dialog and click next.
Select the PubNub data set that we just created.
Now, it will ask the type and values for your Tile, there is a reasonable number of types to select from.
For demo purpose lets create a Clustered Bar Chart with the Live Humidity Values in Redmond and Novato. Select timestamp as the axis of your Tile and Humidity from Novato and Redmond as the values to analyze.
After that, you can name your visual with anything that is meaningful for you.
After you are done, click Apply and your Tile that contains LIVE data will be created and this Tile will keep changing with Time. I’ve tried to create a GIF image to demonstrate it here
I am going to add some Card Tiles as well and for that I’ll select City Noise ratio as it was the most frequently changing value, so I selected it for three different cities and the values changed in seconds according to the LIVE data received, demonstration here
That is all for today, this was just a very simple and quick example of using the LIVE data streams, nevertheless you can create various other dashboards using the available set of data. See ya.