CODEWITHSUNDEEP
powerbipowerquery
Techchamp Pgm
Techchamp Pgm

Reputation: 159

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,

  1. what do they indicate?

  2. why are they clickable and when clicked, they are removed automatically.

enter image description here

Thank you for giving your valuable time!

Upvotes: 0

Views: 33

Answers (1)

Aldert
Aldert

Reputation: 4323

Actually the text "Table" is what it is. In there is a table with columns and rows. By clicking on the "Expand". PowerBI will open the table and "Paste" the columns to your sheet.

It is logical when you think about it because you are looking at a dimension table.

As for the "Value" in your DimProductSubcategory, I am not 100% sure(might be j-son or xml). What you can do is click on it, it will show you what is in there, it does a drilldown. If it asks a question are you sure, press no and copy the query first so you have the original.

Upvotes: 0

Related Questions