Toronto Power BI, Power Apps, Power Automate User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.
 View Only
Expand all | Collapse all

about columns filled with 'table' and 'value' in dimension tables queries within power query

  • 1.  about columns filled with 'table' and 'value' in dimension tables queries within power query

    Posted Sep 08, 2021 01:01 PM

    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.

      thank you for giving your time!



    ------------------------------
    ArunaRamana Program
    student
    ------------------------------


  • 2.  RE: about columns filled with 'table' and 'value' in dimension tables queries within power query

    Posted Mar 09, 2022 12:08 PM
    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
    ------------------------------