Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Joining A table created by Summarize with a sql database table

Hi    From my sql server, i have 9 tables coming. I have created some table using summariazing fn ( called Procedure_acq), but when i go to transfrom data.. i cant seem to find my procedure_acq tab...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Anonymous 

     

    If you created a table with DAX function Summarize, you cannot see it in Power Query Editor. Tables and columns created with DAX language are generated at the model level. They are created after you apply the transformations from Power Query to the model. It's not possible to covert it back to Power Query. 

     

    Instead, you can try the Group by feature in Power Query Editor to summarize data in advance. Then merge two tables per your need.

     

    Reference: 

    Grouping or summarizing rows

    Group rows of data (Power Query) 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous 

 

If you created a table with DAX function Summarize, you cannot see it in Power Query Editor. Tables and columns created with DAX language are generated at the model level. They are created after you apply the transformations from Power Query to the model. It's not possible to covert it back to Power Query. 

 

Instead, you can try the Group by feature in Power Query Editor to summarize data in advance. Then merge two tables per your need.

 

Reference: 

Grouping or summarizing rows

Group rows of data (Power Query) 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.