Those are due to the relationships in the model. If you click the button in the header that looks like two arrows it will allow you to expand that "table" and include whatever columns from it you'd like. This is an easy way to do a join between tables, however if you're using a star schema its best to keep them in their respective tables generally.
------------------------------
Ross Couldrey
------------------------------
Original Message:
Sent: Sep 08, 2021 01:01 PM
From: ArunaRamana Program
Subject: about columns filled with 'table' and 'value' in dimension tables queries within power query
While working on power query in power BI desktop, as I opened each Dimension table queries, I found the right corner columns of each table have one or two columns with 'table' or 'value' as values;
Would anyone help me understand,
what do they indicate?
why are they clickable and when clicked, they are removed automatically.
thank you for giving your time!
------------------------------
ArunaRamana Program
student
------------------------------