Forum Discussion
How to setup relationship for binary data ( HASHBYTES md5)
My datasource is a SQL server and I have my primary key column in binary form i.e if the value is 'gurudev' the value is HASHBYTES('md5','gurudev).
The column is of type binary and is not visible in relationship section to setup relations. How do I handle this. I know I can use views but I need other ways to solve this
Thanks!
3 Replies
hi amitchandak , Thanks for the reply
It says Power BI doen't support binary data yet and I want my report to be using direct query, so transforming to string is making it load slower. Is there any other way around
Hi Anonymous ,
The column which is using Binary as data type cannot see or use outside the Power Query Editor, we can only convert it to other data type such as text or expand it as table to show them.
If you use the Direct Query mode, transform affects the query speed.
If you want to fast response, we recommend changing to Import mode.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
