Forum Discussion
Solved
Divide by Zero Error Related to Incremental Refresh
I am currently having an issue with incremental refresh. I configure it on the desktop for several tables and refresh the report and it refreshes perfectly. After I publish the report it fails becaus...
Hi JEA6489 Issue might be because of the logic please try these
- Review your queries for division operations and ensure denominators are non-zero, using logic like
IF(column <> 0, numerator / column, 0)- Ensure incremental refresh filters don't create empty or invalid partitions.
- Test the queries without incremental refresh and check for any zero or null values in your data.
- Use refresh history in Power BI Service to identify detailed errors.
- Refresh tables individually to locate the problematic table.
Hi JEA6489,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.