Forum Discussion
Intermittent Microsoft SQL: Divide by zero error encountered
Hi Neale
The divide-by-zero error happens due to inconsistent data during refresh. Fix it by:
- Replace division with DIVIDE(numerator, denominator, 0) to handle zeros.
- Ensure the source data is stable and consistent during refresh.
- Look for differences in query behavior.
- Use Power BI Service logs to find specific issues.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKSHi. Are you dividing some columns at some point? it might have an issue getting the data for the division and that's why it's zero. You can change the code to handle it. If your division is in power query you can check: https://learn.microsoft.com/en-us/power-query/error-handling
If it's from SQL you could use case when to check something first.
If you control de values of the division you could take an action to show you when it fails and whats going on.
I hope that helps,
Hi. Are you dividing some columns at some point? it might have an issue getting the data for the division and that's why it's zero. You can change the code to handle it. If your division is in power query you can check: https://learn.microsoft.com/en-us/power-query/error-handling
If it's from SQL you could use case when to check something first.
If you control de values of the division you could take an action to show you when it fails and whats going on.
I hope that helps,
Thank you. One of my divides is based on a SUM of a column that does includes NULLS. My understanding is that SUM will exclude NULL values but I don't know if this is faultless.
