How can you make a report, showing data in real-time – I mean changes are seen immediately after source data change.

Firsty, you have to connect your data in a Direct Query mode (that can be used in Dataverse, SQL server… but not in Excel, csv…):

Then you can work in Power BI Desktop or in cloud.

In Power BI Desktop

You can simply set the auto refresh rate to one second in Format.


In a published visual set the refresh rate up to your needs. 

The shortest interval is 15 minutes, but in Power Query it is refreshed practically in real-time. So you only need some tool to refresh browser page (like pressing F5 every second). There are tons of plugins doing this, like this one:



Leave a Reply

Your email address will not be published.


clear formPost comment