Forum Discussion
Power BI showing #Div/0! while getting data from calculated columns of excel
We have an excel in SharePoint Folder. Every week the folder is updated with a new file.
This excel uses complex calculations to get some values. The BI combines these files and its calculated columns.
When we first open the excel, we see #Div/0! for these values and after a few refreshes the calculated value is seen. Same in the BI, the value from the latest file is seen as #Div/0!. We need to refresh the excel multiple times then refresh the BI to fix this.
Is there a way to automate it? or to make BI take calculated values?
2 Replies
Hi Nivedhana
You can try to remove the calculated column in excel, then calculate it in Power BI after importing the data to Power BI. and can you provide some sample data or file so that can provide more useful suggestion for you.
Best Regards!
Yolo Zhu
Hi Anonymous,
We took the idea of doing the calculations inside the BI. Sorry, cannot provide sample file as the actual file is too complex and involves too many formulas. It has multiple cells with complex calculations and these calculated values are futher used in next cell value calculation. The next cell is used in next cell calculations and so on.. so it takes a few seconds for the data to change from #div/0! to actual value.
