Forum Discussion

GCGradwell's avatar
GCGradwell
Helper I
10 years ago

Grouping data (rolling up)

Hi,

 

I am working on a very large dataset and I am making a report using Power BI. It takes a very, very long time to edit queries, load data etc and is a strain on the PC when all of this is happening.

 

Does PBI feature some kind of data grouping or data roll-up feature where I could condense the current table into a new table where a number of rows could be grouped into one row based on one of the columns and this would be formed into a new table.

 

Does anything like this exist within PBI?

 

Thanks,

 

Greg

Need Help

4 Replies

    • GCGradwell's avatar
      GCGradwell
      Helper I
      10 years ago

      Thanks for the suggestion. This solution accomplishes exactly what I'm looking for, but if I understand the process correctly, Power Query can only accomplish this within Excel?

       

      The file I'm working with is very large and I will not be able to open it in Excel. Is there a way to accomplish what I want without having to import the data into Excel?

       

      Thank you,

       

      Greg

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Sorry.  I reall meant "the piece of Power BI that would be called Power Query if we were still in 2015" :)   The functionality of Power Query is also in Power BI under "Edit Queries"