cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jreina
Regular Visitor

Get real-time data PowerBI

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

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

Hi, @jreina 

 

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.

View solution in original post

6 REPLIES 6
v-angzheng-msft
Community Support
Community Support

Hi, @jreina 

 

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.

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?

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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Greg_Deckler
Super User
Super User

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

Greg_Deckler_0-1636051203367.png

 


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

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

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

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors