Grouping Data From ODBC Connection

[shaunb94]

Hi, 

I am trying to connect data from a second ERP System into a Power BI Report that is already connected to one ERP System. The Data is over 200,000 rows coming from the new source & is resulting in my P&L not populating fully (in the profitbase visual), due to there being too much data. 

I know I need to group the data at an account/period/cost centre level to get the rows down to under 10,000 but when I group the data it removes all the pther columns I am not grouping by which then means I cannot append the data on to the master table (with the data from the other ERP system). 

Does anyone know if I can group the data while also keeping the columns I am not grouping by in the table?

[lbendlin]

Does anyone know if I can group the data while also keeping the columns I am not grouping by in the table?

One of the advanced grouping options for aggregation is "All rows".  That will store your subtables in a table value column per group.