Unable to get the value of Primary key stored as Binary data type in SQL server database

[amshukla]

We are importing data from SQL server to power BI desktop, but when I import (using SQL Query) SQL Server data which contains Primary key as binary data type to Power BI Desktop, even if I can see the binary data column in Query Editor of Power BI Desktop, the column is removed from the resulting table in Data view and Report view, as shown in the attached screenshot.

Because of this I am unable to create relationship between two tables and unable to load it.

In database Primary Key has data stored in the below format:

0x36356138663532353737303234323634616435376562653036386237353632653B643165396531656132343B4637454142384642333343373034464330453836423230303930394437333432

0x31393932393563346633313734353236613631623266353562626331663961653B323238613931366234633B

I have tried below 3 options to get the value of Primary Key but none of these giving the correct value:

• Combine Binary files
• Changing the data type as text
• Converting the binary value to text value

[v-haibl-msft]

@amshukla

As stated in this document, this binary data type column is currently not supported in Power BI Desktop. 

Please vote on this existing idea.

In your scenario, you would need to change the data type of primary keys columns in the original data source.

Best Regards,
Herbert