Forum Discussion

Pandadev's avatar
Pandadev
Icon for Post Prodigy rankPost Prodigy
5 years ago

Incremental refresh , when published and full refresh errros on visuals

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.
Need Help

1 Reply