Forum Discussion

maj's avatar
maj
Helper I
6 years ago

Grouping Data

Hello,   I have a very large dataset (26MM rows) that contains hundreds of customer names.  I want to group them as such:   If customer name is A, group A If customer name is B, group B If cust...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi maj ,

 

This is doable in PowerQuery. Considering the umber of records it is best to do this at the source than in Power BI.

 

What is your data source and type of load - Import or Direct.

 

Cheers

 

CheenuSing

maj's avatar
maj
Helper I
6 years ago

Hi Anonymous,

 

My data source is a dataflow that was created through a connection to an Azure Databricks table.  I created the table in Azure using SQL query.  Are you saying it's best to do the grouping in my query, which feeds the dataflow, which feeds my PBI report?

 

Thanks!

-maj

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    maj ,

     

    Yes  it's best to do the grouping in  query, which feeds the dataflow, which feeds my PBI report.

     

    Cheers

     

    CheenuSing

    • maj's avatar
      maj
      Helper I
      6 years ago

      Anonymous 

       

      I'm not familiar with grouping.  Do you have any suggestion on how to write this in SQL?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi maj ,

         

        Please send me your current query and also share a set of 10000 records in excel . Upload the excel and query to OneDrive or Google Drive and share the link . Please alsso mention what is the result you expect on the sample data.

         

        Cheers

         

        CheenuSing