cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

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

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors