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
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!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors