Merge function is not working

[Anonymous]

Hi All,

I am facing some issues in advanced editor. I am trying to merge two tables but I am getting 1 error. Last 8 months,  my report was working properly. But from last week, I am facing this issue. I have tried to merge the same table but after that also I am facing the same issue. 

I am getting the  below mention error :

"We are unable to determine how many matches the selection will return".

Please help me to resolve the issue.

Thanks in advance.

Regards,

Rahul

[v-qiuyu-msft]

Hi @Anonymous, 

Please check if there is any changes made in data source recently. 

In Query Editor, please find the two columns which are used for merging queries function, check if their data type are the same. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi  @v-qiuyu-msft ,

Thank you for your reply.

I did some workaround in the merge e.g. it was failing because of the null handling and I fixed that

It is working properly now.

Thanks,

Rahul