Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to refresh Power BI datasets every 5 minutes with Power BI Pro License

My customer is having the Power BI Pro license. We have uploaded the Power BI reports with Import mode and they are not interested to use Direct Query since it will cause a huge performance issue due to large number of data.


They need the report dataset to get refreshed every 5 minutes so that they can make the report 90% live. How this is possible ?

Super User
Super User

Hi. I would suggest three alternatives. One of them is premium/embed, when you have your own capacity you can refresh 48 times a day. It's not every 5 minutes but it's pretty close. The second option is considering moving the data model to analysis services that can be refresh everytime you want and them you can live connect that with Power Bi. The third one would be creating a streaming dataset. The only warning I would say about this last one is that those datasets are prepared to be streaming stuff. I mean certain kpis and everything merged in one table that will show those small things I need to know so fast.

Be sure that this is not a whim because real big model bi in streaming is not a good option.


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

Happy to help!

LaDataWeb Blog

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors