I have just set up an incremental refresh in PowerBI desktop and when I published it everything was showing okay in the visuals.
But when i did the first refersh to bring in all of the data , the visuals no longer work.
The query referenced column 'acrftreg'[MTOW Match] which depends on another column, relationship or measure that is not in a valid state.
I have 2 additional tables where I use
Exemptions Table is a sharepoint excel workbook , which is not an incremental refresh
Exemp MTOW = LOOKUPVALUE('Exemp MTOW'[Reg Number],'Exemp MTOW'[Exemp Reg Op],acrftreg[Reg Reg Op])
History Table - which is the incremental refresh
FP Cert MTOW(lbs) = LOOKUPVALUE(History[CertifiedMTOW(lbs)],History[RegistrationNumber],acrftreg[Reg No.])
MTOW (lbs) = acrftreg[MTOW]/0.45359237
MTOW Diff = acrftreg[MTOW (lbs)]-acrftreg[FP Cert MTOW(lbs)] - this is from a table acrftreg which is not an incremental refresh
MTOW Match = IF(acrftreg[MTOW Diff]=0||acrftreg[MTOW Diff]=1||acrftreg[MTOW Diff]=-1,"Yes","No")
Is there any reason why these dont work on incremental refresh of the history table.
