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.

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..