Forum Discussion
Circular reference error
Hi Hasan_iba,
Based on my research, there are normally two ways to solve the circular dependency issue:
- Add the row identifier column to one of your fact tables, then create corresponding relationships with other fact tables.
- Use ALLEXCEPT to remove the calculated columns from the set of columns that become part of the dependency list is a viable option.
For more details about the circular dependency issue, you can refer to this article.
In addition, after looking into your shared pbix file, I would suggest you try using Merge Queries options in Query Editor to merge your "TaskTimephasedDataSet" table and "TaskBaselineTimephasedDataSet" table into a single table, which should make your data mode clear and easier to handle. Here is an article about how to use Merge Queries option for your reference.:smileyhappy:
Regards
Hi Hasan_iba,
Based on my research, there are normally two ways to solve the circular dependency issue:
- Add the row identifier column to one of your fact tables, then create corresponding relationships with other fact tables.
- Use ALLEXCEPT to remove the calculated columns from the set of columns that become part of the dependency list is a viable option.
For more details about the circular dependency issue, you can refer to this article.
In addition, after looking into your shared pbix file, I would suggest you try using Merge Queries options in Query Editor to merge your "TaskTimephasedDataSet" table and "TaskBaselineTimephasedDataSet" table into a single table, which should make your data mode clear and easier to handle. Here is an article about how to use Merge Queries option for your reference.:smileyhappy:
Regards
- Hello! Thank you so much for the detailed explanation. I did bring one required column in the main table from other table and it worked. Much appreciated. Thanks
