Forum Discussion
How to update Power BI every minute
- 3 years ago
Hello Rasmus_B ,
With import mode, you get to schedule a refresh every 30 min for 8 times only per day for a pro license and 48 times for Premuim license.
But you can get the data as a direct query were you can have live data without refreshing, https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- 3 years ago
With Premium you can refresh programmatically more often than 48x per hour, which is merely a UI limitation. That said refreshing an Import cache every minute is not going to work.
Aside from DirectQuery as you suggested, Rasmus_B should also have a look at streaming and push datasets:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming
Hi thanks to you both. Much appreciated. An analysis of both solutions and testing is underway 🙂