Forum Discussion
Solved
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...
can you share a sample of your source data?
vanessafvg
Community Champion
Community Championit 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.
There is nothing to clean in Power Query (left screenshot). Data is ok there. It's just when I Apply changes that the brackets and upper-case appear.
- vanessafvg
can you share a sample of your source data?