Merge Queries error - Expression.Error: We cannot convert the value "[Value]" to type Record.

Question

Hi,&nbsp;I've run into a problem where I am mergeing two queries in where 2 tables are joined by two combined columns. These columns are both texts and are combined first prior to merge query. I receive this error. Running the same tables and merging in excel works. No idea why...&nbsp;&nbsp;also should add, neither column on neither table has any errors nor missing values.&nbsp;&nbsp;Expression.Error: We cannot convert the value "[Value]" to type Record.Details:Value=[Value]Type=[Type]&nbsp;&nbsp;EDIT:&nbsp;Also forgot to mention, I am able to refresh my dataset via the desktop app, I am only getting this error running a schedule refresh.&nbsp;I have checked my credentials in on all my sources.&nbsp;

anonymous · Accepted Answer

Hi,&nbsp;munnaz&nbsp;
Perhaps you can check if there are null or blank values in your Table below, which may be the cause of the error. You can check out the following posts:
Solved: Expression.Error: We cannot convert the value 1 to... - Microsoft Fabric Community
&nbsp;
Solved: Expression.Error: We cannot convert the value to t... - Microsoft Fabric Community
&nbsp;
How to Get Your Question Answered Quickly&nbsp;
Best Regards
Yongkang Hua
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Merge Queries error - Expression.Error: We cannot convert the value "[Value]" to type Record.

2 Replies

Related content

Snowflake connector: "We cannot convert the value null to type Text"

Expression.Error: We cannot convert the value "[Record]" to type List. Details: Value=[Record]

Power Query Merge/Append "Expression.Error: We cannot convert the value "[Binary]" to type Binary."

Propoperties Issue - "Value" instead of list of columns

[Expression.Error] We cannot convert the value "" to type List