syntax change Power query 2016 32 bits and power bi 2013 64 bits

[cdelgadosi]

When running a Excel power query report from ms office 2016 32 bits in ms office 2013 64 bits, my conditional colums change to error because apears  charactes like "#" and "(0000)" at field name.  May some onwe explain me how to avoid that_

[cdelgadosi]

The problem repeats when open workbook builded in Power Query 2016 32 bits and opened Power Query 2016 32 bits or builden 64 bits and opened in 32 bits.

[v-juanli-msft]

Hi @cdelgadosi

When you run a report from a highest version in a previous version, it is not strange to face this kind problem since the something supported in a highest version may not support in a previous version.

Since I am not the expert of Power query in excel, so my answer may not be very well. 

I would recommend you to search a better answer from Power Query Technet formus.

Best Regards

Maggie