Create a Power BI streaming dataset for real-time dashboards

In this video, Patrick looks at how to create a Power BI streaming dataset and use that to create a real-time dashboard. You can easily use something like PowerShell to push data into the Power BI streaming dataset.

LET'S CONNECT!

Guy in a Cube
-- Snapchat - guyinacube

***Gear***

#PowerBI #Streaming #GuyInACube

[sqldevdba]

Patrick, this is awesome. Thanks!
One thing: in your $Time variable definition, you have HH:MM:ss when it should be HH:mm:ss (MM is for month, mm is minute). Took me a second to see why my refresh wasn't updating..

[damien]

Just learning Power bi, and the powershell trick you just showed me blew my mind. What a great idea!

[burtjohnson]

My real world example is for DMARC. Using PoSh to extract email from an Outlook mailbox, unzipping the attachments, reading the data into an array, uploading it to PowerBI. Lots of records every day would be tough to do manually. This video has helped immensely.

[jordanmartinetti]

I've used streaming/push datasets multiple times and I LOVE them. They're great for a smaller database where you can write a few rows immediately and don't have to do a manual refresh. Thanks Patrick!

[patricknahayo]

Greetings Patrick (from another Patrick)
For anyone here who might not see their dashboard refreshed just pin the items individually (for some reason pinning the whole report isn't auto-updating) and happy BYING (lol)

[bnee]

The way he puts the whole things makes it more interesting

[ImAzraa]

Even though we're now calling datasets "semantic models" (which i think its a pretty bs/marketing moniker but whatever) this remains as relevant as ever.
We're exploring this in my company to track seawater ph, temp and opacity to compare dynamicly against feed flow for farming operations.
Use-cases for this are plentyyy and now the tools seem more robust on the azure analysis services side of things too.

good stuff, my dudes.

[simong]

that's great man!!!! so i can hookup real time data sets to power bi and create dashboards and use powershell to define the

[AAa-tnrz]

Could you show how to stream stock prices?

[sqldevdba]

Hey guys. Thanks again for this video. I was able to use this approach to send data from SQL Server Tables using xp_cmdshell in a stored procedure. Fantastic work!

[cinellitiziano]

Hi Patrick!
I use with satisfaction a dashboard with the CPU and RAM monitoring of a VM via Powershell from February 2018! It's beautiful!

[ajones]

Explaining the pros and cons of this along with use cases would be great

[channuangadi]

Searching hole life
Awesome
Thank you

[benjamindbarr]

Thank you for this video, I am trying to do this right now, I am a complete beginner a this Power BI stuff, but if I can make this work for gathering non time critical preventive maintenance data (and thus completely useless data to former generations) I am going to be thrilled.

[cropereira]

Do you have an example using streaming from a database?

[mannerhaushalt]

Great video and great syle! <3

I got 2 questions:
1) What I need, is simply to automate the push once a day (from a Jenkins job). Is still the steaming dataset the way to go?
2) How to easily test this in Power BI desktop before publishing to PBI server?

[RussellRoefer]

Love it. I’ve got a use-case for something just like this. Much appreciated.

[maximmakarovsky]

Thats cool . Thank you Patrick.
And thank you for synoptic example, now going to manage a parking lot with it:))

[muhammadhumza]

Thanks for this video My dataset is getting updated but the only issue I'm getting is I need to manually refresh the dashboard so that new data can be seen in it.
Can someone guide me how to sort this issue because for streaming data I can't reschedule a refresh.

[ashseth]

Wow, certainly looks a better option. I was using Azure stream analytics to push AVG, etc. Values to Power bi but it's still not up to mark in terms of real time. I will try this also. Thanks a lot for sharing.