Table from Salesforce won't refresh due to a missing column on the object

Hi Icey 

It's not in my advanced editor code, so I'm getting an error despite that. I've also copied the code from advanced editor into another Power BI file, and it works fine. It's this one file that it's not working for. 

What is considered sensitive information, and I can post the code from advanced editor?

Thanks. My issue is I'm not sure what formula is giving me that error. It doesn't specify the field that's producing the error. It's just preventing the table from refreshing. I may be explaining poorly. 

I think it's occurring after. It says "5,638 rows loaded" then it give the error, so it feels like there's a formula in the file dependent on that table that can't calculate properly. I just don't know how to locate it and fix it.

Right. I have several of those in this particular table. Any way to identify which is one giving me the error?

This is the full error when i'm refreshing the table:

Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation. Please try again later when there may be more memory available. A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed. '.

I'm happy to paste the formulas, I just don't know which to paste. Will they be in the table failing to load or could they be in a calculated table created off the table that won't load? I just don't know where to start.

Ok, I'll try to do my best to paste all the formulas that use "calculate" from this table here. There are quite a few, as I've sort of been learning as I go, so some of these are obsolete, and I haven't done a great job of cleaning up.

I'm also using generic names like "table1" in place of more business specific terms (I believe that's what you mean by sanitize).

You've picqued my curiosity in that you don't think it fails to load. Do you have a working theory about what's actually happening?

Column1 = 
Calculate(
    Sum(Table1[Revenue]),
    Filter(Table1,Table1[MonthSpent]=[CMREV]),
    Filter(Table1,Table1[ProjectID]=Project[Id]))
+
Calculate(
    Sum(Table2[Revenue]),
    Filter(Table2,Table2[MonthSpent]=[CMREV]),
    Filter(Table2,Table2[ProjectID]=Project[Id]))

Column2 = 
Calculate(
    Min(Table1[Date]),
    Filter(Table1,Table1[Onboarding_Project__c]=Project[Id]),
    Filter(Table1, Table1[Date] >= Project[StartDate]))

Column3 = 
Calculate(
    Sum(Table1[RevenueAtTransition]),
    Filter(Table1,Table1[Onboarding_Project__c]=Project[Id]))
+
Calculate(
    Sum(Table2[Revenue]),
    Filter(Table2, Table2[ProjectID] = Project[Id]),
    Filter(Table2, Table2[MonthSpent] = Date(Year(Project[Closed_Date__c]), Month(Project[Closed_Date__c]), 1)))

Column4 = 
IF(
    (Calculate(
        Sum(Table1[RevenueAtTransition]),
        Filter(Table1,Table1[Onboarding_Project__c]=Project[Id]))
        +
    Calculate(
        Sum(Table2[Revenue]),
        Filter(Table2,Table2[ProjectID]=Project[Id]),
        Filter(Table2, Table2[MonthSpent] = Date(Year(Project[Closed_Date__c]), Month(Project[Closed_Date__c]), 1))))  
            > Project[Value], Project[Value],
    Calculate(
        Sum(Table1[RevenueAtTransition]),
        Filter(Table1,Table1[Onboarding_Project__c]=Project[Id]))
    +
    Calculate(
        Sum(Table2[Revenue]),
        Filter(Table2,Table2[ProjectID]=Project[Id]),
        Filter(Table2, Table2[MonthSpent] = Date(Year(Project[Closed_Date__c]), Month(Project[Closed_Date__c]), 1))))

Column5= 
Calculate(
    Min(Table1[Date]),
    Filter(Table1,Table1[Account__c]=Project[Account__c]))

Column6 = IF(OR(Project[Date]=blank(),Project[Value]=blank()),blank(),
            Calculate(
            SUM(Table1[Revenue]),
            Filter(Table1,Table1[ProjectID]=Project[Id]),
            Filter(Table1,Table1[MonthSpent]=Dateadd(Project[StartDate],14,MONTH))
            ))

Column7= 
CALCULATE(
    CountA(Table1[Id]),
    Filter(Table1, Table1[Project__c] = Project[Id]))

Column8= 
IF(
    CALCULATE(
        COUNTA(Table1[Id]),
        Filter(Table1, Table1[First] = TRUE),
        Filter(Table1, Table1[Project__c] = Project[Id]),
        Filter(Table1, Table1[EndTime] <> blank())) 
        >= 1, 1, 0)

Column9 = 
IF(Project[Closed] = 0, Blank(),
DATEDIFF(
    Project[StartDate], 
    Calculate(
        FIRSTNONBLANK(Table1[EndTime], 1),
        Filter(Table1, Table1[Project__c] = Project[Id]),
        Filter(Table1, Table1[First] = TRUE),
        Filter(Table1, Table1[EndTime] <> blank())),
    DAY))

Removed Column8 and got the same result. Could the issue be coming from calculated tables that are dependent on this table?

I'll look for that specifically. Column4 has that construct for instance. 

You said earlier you didn't think it was failing to load. Why do you believe that?