Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Table does not show up in Query Editor

Hello everyone!   I am not advanced user of Power BI and have some problem.   In the data view I created new table with the column that combines distinct value from the 2 columns from other table...
Need Help
Show and Tell
  • OwenAuger's avatar
    OwenAuger
    8 years ago

    Hello Anonymous

     

    The simple answer is that calculated tables created with DAX (in the data view) are not visible in the Query Editor (Power Query).

     

    You may load tables via Power Query, and then, once loaded, add calculated columns or create further tables referring to those tables with DAX, but not the other way around.

     

    Your only option really is to create your "union" table in Power Query, using functions like Table.Distinct and Table.Combine, then you will be able to edit it further in the Query Editor.

     

    Regards,

    Owen

OwenAuger's avatar
OwenAuger
Super User
8 years ago

Hello Anonymous

 

The simple answer is that calculated tables created with DAX (in the data view) are not visible in the Query Editor (Power Query).

 

You may load tables via Power Query, and then, once loaded, add calculated columns or create further tables referring to those tables with DAX, but not the other way around.

 

Your only option really is to create your "union" table in Power Query, using functions like Table.Distinct and Table.Combine, then you will be able to edit it further in the Query Editor.

 

Regards,

Owen