Forum Discussion
Certain column data is appearing in brackets
Hello. I've been trying to relate two tables in Power BI and I haven't been able to do it because one of those tables has the ID column between brackets. So the IDs are not the same: one has brackets and the other doesn't.
What I don't understand is why I can't see those brackets when I transform data: import the database and make any changes. But, when I go to the Data view in Power BI, the brackets suddenly appear. There go two pictures:
You can even see how the first line should be the same, but when I apply all changes to the Data, the brackets are still there.
Thanks!
can you share a sample of your source data?
7 Replies
It's not visible in Power Query. The first of the two screenshots is from Power Query editor. There are no brackets there.
- vanessafvg
Community Champion
when you say related, where are you doing this power query or in the relationship view?
i am not sure about the brackets but another issue could be , the issue is one is upper case and the other is lower case, power query is case sensitve, change both sides to upper and the try to relate again if its in power query.
also trim and clean both sides there might be whitespaces
I meant I was trying to relate them in the relationship view.
Uppercase/Lowercase might me also be de issue. But why is it transforming, the same way it transforms from no-bracket text to text between brackets?
- vanessafvg
it is weird are you able to share some sample source data?
did you try cleaning both sides first, i always find cleaning and doing a bit of transforming does help sometimes, ie format clean and trim and then change all to upper case.
