March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I now receive the error
"Failed to save modifications to the server. Error returned: 'MdxScript(Model) (69, 67) A division by zero has been encountered. The current operation was cancelled because another operation in the transaction failed. '."
when trying to refresh a report. This didn't happen on previous refreshes even this morning, and nothing has been changed either in the report or in the data the report uses. I tried removing all the measures which use division to make it impossible for anything to divide by zero. Yet I still received this error, although sometimes with different numbers referenced (the "69, 67" in the pasted text above might change to "161, 67" or "41, 67").
I'm stumped. Any ideas on what's going on here?
Solved! Go to Solution.
Tested all of these. Clearing the cache then refreshing each table individually got it to start working again! I've also updated the published version on the PBI service. Thank you so much!
Hello @Oaabwen42 ,
maybe this division is occuring in power query and is giving an error, can you try to check this.
also, if you didn't find the reason, I suggest you open an issue with microsoft support, it may be a bug.
https://community.fabric.microsoft.com/t5/Issues/ct-p/PBI_Comm_Issues
Proud to be a Super User! | |
Even if you removed measures with division, it’s helpful to wrap any division in DIVIDE (instead of /), which handles zero safely:
SafeDivision = DIVIDE(Numerator, Denominator, 0)
If null values are present, update measures to handle them by using COALESCE or IF(ISBLANK(...)).
Sometimes, cache or background processes might retain old errors. Save and restart Power BI Desktop to clear any cached data or residual errors.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
@Oaabwen42 not sure what these coordinates are, and I don't think you can see mdxscript.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Oaabwen42 very hard to tell since you have removed all measures using division. Cannot think of anything else except checking the measure? Do you have any visual calculations?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
No visual calculations. There are filters on visuals, but none of those use division in any form. Is it possible that something different is wrong and this is just the closest error message PBI could give to the problem?
Alternatively, is there a way to directly look at MdxScript(Model) (69, 67), assuming that 69 and 67 are coordinates?
@Oaabwen42 interesting, does the service have the same error message?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Essentially, it says "MdxScript(Model) (159, 67) A division by zero has been encountered."
@Oaabwen42 is this happening on the service or on the desktop? if it is on the service, can you try to refresh the desktop to see if it works or you might get a different error message.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
The error message I shared is on desktop, although the error occurs on the service too
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
92 | |
91 | |
79 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
72 | |
55 |