Get real-time data PowerBI

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.