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 table.. i want to join these tables using many to many relationship.. Is this possible ?? how can i acheive it ?

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.

3 Replies

  • speedramps's avatar
    speedramps
    Super User
    4 years ago

    Hi as100

     

    It is bad praticve to use many to many in PBI, consider modelling you data better.

     

    If you must have a manay to many then ...

    In PBI go to the relationship screen

    click on the relationship 

    you can then edit the relationship propeties.

    see https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

     

    I have taken trouble to help you, now please help me by giving kudos.
    Please click the thumbs up if you like me trying to help you and click Accept Solution if I have fixed you problem.

    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello 

      Maybe I phrased that wrong.. im actually looking to merge two tables.. 

  • v-jingzhang's avatar
    v-jingzhang
    Community 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.