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.

  • Download DriverFix (verified download file).

  • Click Start Scan to find all problematic drivers.

  • Click Update Drivers to get new versions and avoid system malfunctionings.

  • DriverFix has been downloaded by 0 readers this month.

Follow the troubleshooting tips to fix the error at hand.

 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”.

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.

This guide will help you become an expert in Power BI!

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:

  • 5 free cloud accounting software to keep your books updated on the fly
  • Top 3 browsers for seamless SharePoint use
  • How to refresh data in Power BI [STEP-BY-STEP GUIDE]

If the advices above haven’t solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

Still having issues? Fix them with this tool:

SPONSORED

  • PowerBi tutorials and guides

Email *

Commenting as . Not you?

Comment