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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Gandhia
Helper I
Helper I

Scheduled refresh

From Microsoft documentation: "Power BI deactivates your refresh schedule after four consecutive failures..."

Question: What practically means "failures"? I mean is it failure if there is no anything to refresh (so the data is exactly same as when refreshing previous time). So after all I want to know if it does matter if I put Scheduled refresh for example every hour - And if there is day that no one is refreshing data; Does it matter? So should I put the refrehsing daily, or can I set it every hour although there will not be changes every time?

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. Failure means that there is an error in the process of getting the data from source or the transformations involved. For example, if there is a renaming of columns at Power Bi and you change a name of an excel column, then the transformations might fail because they can't find the old column name. Another example if you change the file name.

If the data is the same it doesn't matter as long as it can read it and bring it to power bi. The refresh process will replace the data just read overwriting current one. It won't figure out there wasn't a change at all.

I hope that helps,


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

Happy to help!

LaDataWeb Blog

View solution in original post

1 REPLY 1
ibarrau
Super User
Super User

Hi. Failure means that there is an error in the process of getting the data from source or the transformations involved. For example, if there is a renaming of columns at Power Bi and you change a name of an excel column, then the transformations might fail because they can't find the old column name. Another example if you change the file name.

If the data is the same it doesn't matter as long as it can read it and bring it to power bi. The refresh process will replace the data just read overwriting current one. It won't figure out there wasn't a change at all.

I hope that helps,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors