While trying to create a table visualization in Power BI with calculated columns that contains measures that also based on that table, you may encounter Power bI error a circular dependency was detected in Power BI Service. This seems to have affected many users with different formulas as reported in the Power BI community.
I am trying to create a table visualization in Power BI. Where I am showing sales by category and target %. Now I am creating 2 calculated columns in it. The first column tells me Yearly Sales target. Which is as below:
Monthly Sales Target = (1 + Target%) * [MonthlySales].
I am getting the error as “A circular Dependency was detected”.
Follow the troubleshooting tips to fix the error at hand.
How to resolve Circular dependency error in Power BI
1. Check Power BI Limitations
- If you are trying to have two calculated columns that contain measures that are also based on that table, then it is not supported by Power BI.
- So you need to tweak the formula so that the measures are different in two tables.
- For more information on Power BI Circular Dependencies, read Understanding Circular Dependencies in Tabular and PowerPivot article by Alberto Ferrari.
2. Use Excel for Data Preparation
- If you are trying to do such data preparation in PowerPivot, you may want to try Excel to do the same preparation.
- In case the data volume is not too large, you can use Excel for data preparation and then import it into PowerPivot.
- If the data volume is too large to prepare data in the Excel app, consider using Power Query to fix the issue.
3. Other Solutions to Try
- If the issue is not with your calc column, the issue can occur if you already have other calc columns already.
- Also, if your table doesn’t have a primary key, Power BI won’t allow you to create multiple calc columns.
The Circular Dependencies concept can get complex if you miss the basics while creating the tables and prepare the data. Try to follow the troubleshooting tips in this article and check if you are able to resolve “a circular dependency was detected” Power BI error.
RELATED STORIES YOU MAY LIKE: