Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Merge function is not working

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Status: New
Comments
v-qiuyu-msft
Community Support

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
Not applicable

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