Today I’d like to demonstrate an example on how RealTimeDatasets in Power BI may be used.
Of Course there are multiple possible “real world” scenarios to use this functionality like showing the temperature, humidity or actual value of whatever IOT device. I decided to track Twitter as it was one of my own interests to see some stats about tweets.
So lets start.
Create Streaming Data Set
There are multiple ways on how to create a Streaming Data Set. You may find all of them here: LINK
I’d like to start from an existing Dashboard where I’ll just create a new tile
Once you finished that step, you now have to select an existing data set or to create a new one. I created a new one.
Next step is to select the type of data set you’d like to create. The API type is just perfect for what we are going to do.
Now we are going to define the fields which we would like to fill with Information from Twitter. As I wanted to track original and retweeted tweets, I added fields for the originial and the reteweeted ones. Fields are such as
- Is Retweet to identify a tweet as RT
- Tweet ID (Original/RT)
- User (Original/RT)
- Created Date/Time (Original/RT)
- Place (Original/RT)
On the bottom of the above window, make sure to set the checkmark to keep all added values – otherwise you’ll only see the values which are added by MS Flow as long as you have the report open.
Create the Flow
Now it’s time to create the magic. First set a trigger for new tweets and set a hashtag you’d like to track. Now I wanted to check if it is a retweet or an original tweet. Therefore I added a condition and set the condition to @empty condition. You can only set this in Extended mode – I used it to check if field “Original Tweet Username” has any value.
Then I created the “add row to dataset” for each condition. You have to select your Prior created Streaming data set here.
Design the Report
Now as we have taken care of the data stream and waited some minutes/hours to collect some data we can start over to create a report.
Select the dataset you created and start Building the Report. For the map view, I took the visual ‘Flow Map’ from market place. You should from time to time check for new available stuff – sometimes you can find really cool stuff there. Additionally I added just a list and 2 Counters.
See here how it works. You may see here live data for #Dynamics365