How to remove curly braces from an ID to connect tables?

[Anonymous]

Hi all,

I am trying to import some tables using Direct Query and facing an issue while creating a relationship between the tables.
The Key from one of the table randomly contains curly braces around the ID. I tried checking the actual data set and it does not contain these braces. Any idea on how to fix this issue and connect these tables?

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

Right click on the column>select "Replace values":

Then key in { :

And }:

And you will see:

For the sample .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[mahoneypat]

In the query editor, you can add two Replace Values steps from the Home tab in the ribbon.  Just put { or } in the top box and nothing in the lower box.  It will replace them with nulls, and then you can relate the two columns.

Pat