Get real-time data PowerBI

[Anonymous]

Hi

I would like to know information on how to display some data in real time on the dahsboard POWERBI. Is there any method to do it?
Thanks

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

If the data is not required to be strictly real-time, then you can use the direct query mode to connect to your database.

More about DQ vs Import

direct query vs. import

DirectQuery, Live Connection or Import Data? Tough Decision!

If you want the data to be strictly real time, in addition to what @Greg_Deckler  mentioned above, maybe you can also try using automatic page refresh, but this requires you to have Premium capacity support.

When you monitor critical events, it's important for data to be refreshed as soon as the source data is updated. For example, in the manufacturing industry, it's critical to know when a machine is malfunctioning or is close to malfunctioning. If you're monitoring signals like social media sentiment, you want to know about sudden changes as soon as they happen.

refer:

Automatic page refresh in Power BI

Real-Time Page Refresh in Power BI Desktop

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, thanks for your response.

To perform this technique of data collection in real time, do I need a powerBI Pro or PowerBI Premium license?

[Greg_Deckler]

@Anonymous DirectQuery does not require Premium. Automatic page refresh is limited to a mimimum of 30 minutes without Premium.

[Greg_Deckler]

@Anonymous Yes, you would add a dashboard tile in the Service, there is a specific tile for streaming data. 

[Anonymous]

To perform this technique of data collection in real time, do I need a powerBI Pro or PowerBI Premium license?

[Anonymous]

Hi, thanks for your response.
I want to show in real time some data that comes from a SQL database, is this option the only one? Is there another way to display data in real time?

Thanks