Forum Discussion

jfat's avatar
jfat
Frequent Visitor
3 years ago
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...
Need Help
  • vanessafvg's avatar
    vanessafvg
    3 years ago

    can you share a sample of your source data?

Arul's avatar
Arul
Icon for Super User rankSuper User
3 years ago

jfat ,

It will be visible in Power Query Editor, just remove the brackets and try to create the relationship.

Thanks,

Arul

jfat's avatar
jfat
Frequent Visitor
3 years ago

It's not visible in Power Query. The first of the two screenshots is from Power Query editor. There are no brackets there.