cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Refresh more than 8 times

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 ? 

3 REPLIES 3
Highlighted
Super User I
Super User I

Re: Refresh more than 8 times

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



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Highlighted
Helper I
Helper I

Re: Refresh more than 8 times

HI @nickyvv ,

 

On-Demand refresh also count towards the daily limit. 

 

image.png

Highlighted
Super User I
Super User I

Re: Refresh more than 8 times

Funny you mention that 😁, because on that same page it says:

image.png

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.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors