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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Novice_user
Regular Visitor

Processing error: The number is out of range of a decimal value.

Hello

 

I've had a dataset that had been working fine with a Scheduled Refresh. Until recently where I did make some data transformations and published the new file. When I manually publish a version it works fine, but as soon as I set a scheduled refresh it fails and I'm confronted with this error. 

 

Furthermore I cannot even identify the table/ column where the error is located. When refreshing all tables it doesn't show me any errors.

 

Would appreciate some help.

 

Best Regards,

Brennan

Novice_user_0-1624880579084.png

Novice_user_1-1624881969712.png

 

7 REPLIES 7
Novice_user
Regular Visitor

I found a solution by editing the query. Go into the table if you can identify it and remove all errors. That helped me run the scheduled refresh.

 

However I haven't been able to isolate the error and correct it, since I am working with a large dataset.

Novice_user
Regular Visitor

I would appreciate it if therer was a community or network where you could yourself work hands-on in PowerBI and troubleshoot. Please do let me  know if such a group does exist, I would very much like to offer help as well and knowledge share.

JasonP
Frequent Visitor

Having the same exact issue. Any solution?

JasonP
Frequent Visitor

I figured out my issue. I had some data that didn't come through right and was showing up as "0". I was later dividing that number so when it tried to divide by 0, it hit an infinite number. Problem solved now. 

Same for me! I just replaced errors with 0 and it was fixed

Mine was caused by the same issue, dividing by 0 and getting infinity.

alisondonoghue
Frequent Visitor

I am having the same issue. No changes were made but the scheduled refresh is giving that error even though manually it is fine. 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors