Circular Dependency in the Desktop but not in the Fabric Service after March 2024 Update

[BI4Kids]

Hello 

After the March 2024 update a Circular Dependency Detected error began to appear in a relationship that seemed to be fine since forever. In fact, the Fabric Service does not issue this error. What's worse, any changes I try to make to the dataset regardless of where the changes are made; this error pops up and completely ignores applying the changes I want to make. Is there a "bug" in the latest Desktop update? Why did this error not exist prior to this? I need help, I can't seem to shake off this issue and I have several updates I need to make to this dataset which cannot be made in the Fabric service.

[ebeery]

@v-yetao1-msft no, the April update has not solved this issue.

[v-yetao1-msft]

Hi all ,

I searched for recent known issues and didn't find anything similar. So I need more information to confirm and restore this issue. Are you guys able to restore this issue on the latest version (by creating a similar report instead of opening the previous one directly). Or provide a simple pbix file to prove this issue?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Community Support Team _ Ailsa Tao

[BI4Kids]

@v-yetao1-msft 

Below are the pertinent Measures and Tables for this example. I am still not able to get this working in April Update.

Measures:

FosterCasesCensusMeasure =
CALCULATE (
    COUNTROWS ( 'Cases' ),
    FILTER (
        'Cases',
        AND (
            AND (
                NOT ( ISBLANK ( 'Cases'[FosterIntakeDate] ) ),
                'Cases'[FosterIntakeDate] <= LASTDATE ( 'Calendar'[Date] )
            ),
            OR (
                ISBLANK ( 'Cases'[FosterDischargeDate] ),
                'Cases'[FosterDischargeDate] > FIRSTDATE ( 'Calendar'[Date] )
            )
        )
    )
)

Custom Table:

Bednights = SUMMARIZECOLUMNS (

    'Cases'[Agency],

    'Cases'[Program],

    'Cases'[Circuit],

    'Cases'[Branch],

    'Cases'[FundingOrg],

    'Cases'[RateLevel],

    'Calendar'[Date],

    DATESBETWEEN (

        'Calendar'[Date],

        DATE ( YEAR ( MAX ( 'Cases'[ExportDate] ) ) - 15, 1, 1 ),

        MAX ( 'Cases'[ExportDate].[Date] ) - 1

    ),

    "Bednights", CALCULATE ( [FosterCasesCensusMeasure] )

)

Calendar

DateMonthMonthNumYear 4/1/2024 Apr 4 2024 4/2/2024 Apr 4 2024 4/3/2024 Apr 4 2024 4/4/2024 Apr 4 2024 4/5/2024 Apr 4 2024 4/6/2024 Apr 4 2024 4/7/2024 Apr 4 2024 4/8/2024 Apr 4 2024 4/9/2024 Apr 4 2024 4/10/2024 Apr 4 2024 4/11/2024 Apr 4 2024 4/12/2024 Apr 4 2024 4/13/2024 Apr 4 2024 4/14/2024 Apr 4 2024 4/15/2024 Apr 4 2024 4/16/2024 Apr 4 2024 4/17/2024 Apr 4 2024 4/18/2024 Apr 4 2024 4/19/2024 Apr 4 2024 4/20/2024 Apr 4 2024

Cases

ERCaseIDAgencyBranchCircuitExportDateFundingOrgFosterIntakeDateFosterDischargeDateProgramRateLevel 646C60AC468B0D3585258B00006D968E 4KIDS of South Florida Treasure Coast - FC Treasure Coast 4/18/2024 1:33:34 AM Communities Connected for Kids  Inc. 4/12/2024   Foster Care General Treasure Coast 428A5A66BDB5B09485258AFD0043D0EC 4KIDS of South Florida Treasure Coast - FC Treasure Coast 4/18/2024 1:33:34 AM Communities Connected for Kids  Inc. 4/11/2024 4/15/2024 Foster Care TIER 1 (CCK) DC89298C93B88CC085258AB5005A9D67 4KIDS of South Florida Broward - FC Broward 4/18/2024 1:33:31 AM Child Net - Broward 4/10/2024   Foster Care TIER 3 (ChildNet) 6EFF8CD2FE6A6EA3852588990049485D 4KIDS of South Florida Treasure Coast - FC Treasure Coast 4/18/2024 1:32:55 AM Communities Connected for Kids  Inc. 4/9/2024 4/10/2024 Foster Care TIER 1 (CCK) 0883D74D10D9CA12852588990049580B 4KIDS of South Florida Treasure Coast - FC Treasure Coast 4/18/2024 1:32:55 AM Communities Connected for Kids  Inc. 4/9/2024 4/10/2024 Foster Care TIER 1 (CCK) A3DB8BB75278DB6D85258AE6005679C7 4KIDS of South Florida Treasure Coast - FC Treasure Coast 4/18/2024 1:33:32 AM Child Net - Palm Beach 4/8/2024   Foster Care TIER 2 (ChildNet) FFFCB7A2D4994A37852586FF004DA281 4KIDS of South Florida Broward - FC Broward 4/18/2024 1:32:32 AM Child Net - Broward     Foster Care - Not Specified - FFF6970A8B677664852585BA0067D89A 4KIDS of South Florida Broward - FC Broward 4/18/2024 1:32:17 AM Child Net - Broward     Foster Care Unpaid FFF16FE0F5B0AA03852589EF0053D13A 4KIDS of South Florida Palm Beach - FC Palm Beach 4/18/2024 1:33:22 AM Child Net - Palm Beach     Foster Care Unpaid

[v-yetao1-msft]

Hi @BI4Kids 

Thanks a lot for the sample, I tested it based on the sample you provided. I didn't encounter any DAX related errors during the whole process. You can refer to my screenshot. 

The version I'm currently testing is 2.128.952.0 64-bit (April 2024). If you've updated to that version and are still having problems testing it out, I'd suggest mentioning a Support Ticket. A dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

Best Regards,
Community Support Team _ Ailsa Tao

[BI4Kids]

@ebeery @sgroth001 @NarWind 

I ended up opening a trouble ticket on this issue. Have any of you been able to resolve the matter in your respective models? Just curious, feel like I'm the only one on planet earth having issues with a Circular Dependency that is not a circular dependency 🙄

[NarWind]

@BI4Kids - I don't think it's resolved yet. For my client, we ended up disconnecting the relationships to the calculated table and instead updated the measures derived from that table to use the TREATAS pattern rather than the direct relationship.

CALCULATE(
    SUM(CalcTable[Column1])
    ,TREATAS(VALUES(Dimenion1[Column1]), CalcTable[DimensionColumn1])
    ,TREATAS(VALUES(Dimenion2[Column1]), CalcTable[DimensionColumn2])

)

Everyone, please vote up this ticket so that it's on Microsoft's radar.

[BI4Kids]

@NarWind @ebeery @sgroth001 

Good morning all, 

Below is a snapshot of the email response from MS BI tech support:

Does anyone know how or where to go to setup an environment variable in Power BI Desktop? 🤔

UPDATE: this lnik shows how to set that up in Windows...

https://phoenixnap.com/kb/windows-set-environment-variable

[NarWind]

https://www.redswitches.com/blog/environment-variables/

Look for "Method #1: Set Environment Variables Through the GUI"

Then add the environment variable as described in the technician's email.

[v-yetao1-msft]

Hi all ,

This has been confirmed as a known issue . No specific timeframe for a fix has been provided yet, I'll come back with an update if there is any progress.

Best Regards,
Community Support Team _ Ailsa Tao