Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
d474boy
Helper I
Helper I

Why is Power BI Service trying to refresh my data source at 2am when it isn't scheduled to do so?

I originally set a data source on my work computer to refresh at 2am.

I had an email in the morning saying that the refresh had failed.

I then realised that my work computer is not connected to a network at 2am.

So, I changed my auto refresh time to 8am.

BUT I am still getting emails saying that the 2am refresh has failed. Why?

1 ACCEPTED SOLUTION

Hi @d474boy ,

 

The schedule refresh time is set as showed under Schedule refresh option in picture1, once you can save this changes, there is no relation with your company.

 

So the schedule refresh works well as you set currently showed in picturee2, right?

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-xicai
Community Support
Community Support

Hi @d474boy ,

 

If you have used on premise data gateway(personal mode) and configured schedule refresh for your dataset, then the personal gateway needs always to be online status, otherwise, it will refresh fail.

 

So recommend you install and configure the on premise data gateway(Standard mode), then add all data sources of your dataset under the gateway, this way, you are able to set schedule refresh using the on premises data gateway, see more details:https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-scheduled-refresh.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

The data source is a spreadsheet on my company's Sharepoint DMS. I didn't think this used a data gateway but I really don't know as it is all very confusing. The first sceenshot says it doesn't need a gateway though.

 

I certainly can't control how the data gateway is set up as this is controlled by the IT Department.

 

Looking at the second screenshot, it appears that my 8am refreshes ARE working. Could it be that my company has set the DMS to resfresh at 2am in addition to my 8am option?


Schedule for Date Table data source on DMS.jpgSuccessful refreshes of Date Table data source on DMS.jpg

Hi @d474boy ,

 

The schedule refresh time is set as showed under Schedule refresh option in picture1, once you can save this changes, there is no relation with your company.

 

So the schedule refresh works well as you set currently showed in picturee2, right?

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

venal
Memorable Member
Memorable Member

Hello d474boy,

 

Might be enabled the option in Dataset.

d474boy-dataset settings.JPG

 

If this post helps, then please consider Accept it as the solution to help the other members find it more

 

The auto refresh IS enabled... for 8am! Not 2am. Why is it still trying to refresh at 2am?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors