justin.lamantia - Thursday, July 12, 2018 10:30 AM
The Query Is from SQL, an im Running that Query thru EXCEL Power Query. When i put that query into Excel Power Query it Returns
<Binary data> as ID
and not...
0x004700DD24EBF06E46E0A707561C0BE83EC0 as ID
Create a view on the SQL with the type conversion and then query it! 😎 You can also do the conversion as a step in the Power Query but that is less efficient.