The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
I have a health check report that I am trying to autoamte in Power BI. The problem is that the dataset needs to be refreshed every hour 24x7. If I use import query mode I cannot refresh momre than 8 times a day. If I use Direct query mode then many of my measures and logics do not work.
Is there any other workaround for this ?
I'm afraid there's not a quick or cheap solution. Unfortunately you can only do a scheduled refresh 8 times a day on shared capacity (Power BI Pro). With Power BI Premium you can do it up to 48 times a day.
You can however always schedule an on demand refresh, but for that you have to push a button, so that may or may not work in your case. On-demand refreshes do not count towards the daily limitation.
Please have a look at the documentation for more info: Configure Scheduled Refresh.
Did this help you or did I answer your question?
Then please give kudos or mark my post as a solution!
My blog: nickyvv.com
Funny you mention that 😁, because on that same page it says:
And in my experience this statement is true, they do not count to the daily refresh limitation. So I already send feedback on that page to correct this.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
53 | |
22 | |
11 | |
10 | |
9 |
User | Count |
---|---|
112 | |
32 | |
28 | |
18 | |
18 |