Creating real time dashboards in Power BI with push datasets

Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined with an Import model already in place. This video introduces the architecture of push datasets.

[humdla]

this is absolutely wonderful. thank you for the thorough introduction! Last time we needed "real time" for a report we resorted to direct query and "refreshing" - super slow and inconvenient... I hope to try this out soon!

[wexwexexort]

This sounds really exciting. Great job, great explanation.

[MilhouseBS]

Always good to see dashboards to get some love.

[EduardoAdanHuizaZarate]

This is crazy, I am in a project that require push datasets. Going to read all the documentation right now :)

[MrDaoneill]

What a foruitous video! I have recently been posed the challenge to find a way to provide real time dashboard within my organisation and this information and tool will be invaluable. Marco & Alberto thank you so so much for this video and the article.

[emirtuncer]

It sounds fantastic. Im very excited to watch the video. Thanks @Sqlbi team

[yidaveding]

thanks for sharing. excellent video. This push data method also opens up a lot of new possibilities.

[BillyBob]

You guys did it again! Seriously this is great stuff

[Tschick]

Great stuff!
It might be very helpful for a specific dashboard of a client, where I am currently using direct query.
Thanks for the video

[meipolomiga]

thanks for sharing this video..so wonderful..

[federicocomito]

Thanks for the amazing video! I apologize in advance for my ignorance but, is the api call still gonna work if my machine is off?

[suvarchaladevikanchustambh]

Hi, For continuous running of dashboard do we need to run the powershell application continuously? Is it possible for running powershell command automatically?

[banklc]

show Confirm-PushDataset -Model 'C:\xxx.\desktop\Contoso.bim' no command name cmdlet: when i repeat your work in the powershell

[GregKramerTenaciousData]

Is anyone else getting this error message: Confirm-PushDataset : The term 'Confirm-PushDataset' is not recognized as the name of a cmdlet, function, script file, or operable
program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:3 char:1
+ Confirm-PushDataset -Model 'C:\Demo\Contoso.bim'
+
+ CategoryInfo : ObjectNotFound: (Confirm-PushDataset:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException

[nagarjunaambati]

I have to build realtime dashboard. but for one of the visualization I need to perform Pivot transformation. is this achievable in though this process? (Pivot transformation not supporting when using direct query)

[abhijithvm]

Very informative video, and I believe it's really helpful for aspiring data analysts. Currently, I am preparing a dashboard based on my day-by-day expenses. Sir, is there any possibility to make it a live dashboard based on my Excel data? Is it possible or not? Finally, thank you for the informative video.

[ShekarCReddy]

You are running a Command line utility (your Push app) in the shell on your desktop. How does that work in Power BI Service as a command line app? Do we need to install anything on the Service?

[AJ-alt]

I haven't finished the video, but ist his possible when im getting the data from a connected database, say Smartsheet or other online data source?

[GagandeepSingh-dbeh]

I have a question regarding the tabular editor, Like We have some client laptops I made one model and deployed it in SSAS. Then The next day I am on another laptop can I load deployed model setting in the Tabular editor or do I need to bring saved local to new machine and open that file then only I can see all my work like CKF, Measures, relationships etc. thanks in advance

[jamesross]

is it just me or is the whole live dashboards really not worth the cost! i mean when would you benefit from live dashboards in business over a regular report.