Creating real time dashboards in Power BI with push datasets

One other solution is to FTP directory running a script that is running the same script that updates the data.

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

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)

Thanks looks interesting.. however just question/limitation with push datasets.. although looks fantastic to see live data but --for me it falls on duplicates.. its tough to dedup live data ..if the data coming in is not filtered properly and if there are data surprises.
It can give erroneous dashboard.
some existing tools which uses Push -data on ports like machine logs.. struggles with matching legacy and live data
Over night pull data can be cleansed and filter through business rules ..etc.. but liked your diagrams and data flow presentations

Great solution!

How is the Dual mode in Power BI different from this approach sir?

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

thanks for the informative video. By any chance, is there an alternative tool that could generate .bim as tabular editor is not open source and neither it is a freeware. Your feedback and comments are appreciated

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?

thanks for sharing this video..so wonderful..

This is really helpful. Is there anyway that we can add slicers?
At present, we cannot add slicers to dashboard.
If we add it to the report, we have to refresh the page for the latest data.
Is there any other way to do this?

Hi thanks for a great solution. I've worked on it and made it working as far as incrementally refresh the push dataset after batch updating from DAX results from its twin in-memory model. Then I am hitting the wall with RLS - is RLS not supposed to be working with push dataset? I reviewed microsoft documentations etc, but couldn't find a definite answer for that.

Is the hybrid table going toachive the same

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

I love it!

this is just wow thank you !

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

Awesome Stuff! Thanks. Will this work with Oracle Database?

Thanks for the great video,
I get,
Failed to get shared database name. Description: {"Message":"API is not accessible for application"
When trying to refresh data from import DB to push DB

Thank you very much! So seems that don't work very well to "update" data.

Excelent video! Would you recommend use this tool if the original data source are json files in an Azure Blob Storage?

where did you get your chair ?

amazing

I really like the idea, but... I got the feeling that you present Direct Query in pure form which - I guess is not best - but we have dual storage mode and aggregations which are increasing DirectQuery feasibility a lot. And soon the automatic aggregations will be introduced. Having it in mind is push dataset is really better solution?

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

What about building a composite model with a similar architecture to what you described? You have your import tables and then a single DQ table that pulls in today's data? I know you have the DAX limitations, but it seems like the performance component would be mitigated in a large way.

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

You guys did it again! Seriously this is great stuff

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

Excel explanação, parabéns!

I think we can use power automate to push the data, no?
there is a power automate "add rows to a dataset" connector.

Always good to see dashboards to get some love.

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?

Will this tool work with power bi report server?

Thank you

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!

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

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.

This sounds really exciting. Great job, great explanation.