Data refresh error

[eWise]

Hi everyone, 

Can someone help me figure out what is happening. My model has been working and refreshing until today when I got the error below;

I think there has been some changes in the source database (CosmosDB) but I don't know where to start looking.

Thanks,

[eWise]

Thanks @amitchandak and @v-jayw-msft After another attemp to refresh, the power query error actually pointed to the errant column and I was able change the datatype.

Cheers!

[v-jayw-msft · Accepted solution]

Hi @eWise ,

The error message shows there are columns in the Order table that is Record type, which is not supported to compare.

Go to Query Editor and check the column and change it to other type.

Best Regards,

Jay

[amitchandak]

@eWise , You have to open power query and check order table, is there some column coming as a record. where you have applied a filter