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?