Forum Discussion
Consolidate/Condense Large Data Source
Hi brynjlai ,
You can use the group by feature in Power Query to summarize your data before loading it into the model. If you don't have a month and year columns yet you can add them first and then be as granular as needed in the group by dialogue box. Once the data is loaded, you can then copy the table from the data view into an Excel file. Alternatively, you can use DAX Studio to export if the file is too big to be just copy pasted (https://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax-studio-methods/)
Hi brynjlai ,
You can use the group by feature in Power Query to summarize your data before loading it into the model. If you don't have a month and year columns yet you can add them first and then be as granular as needed in the group by dialogue box. Once the data is loaded, you can then copy the table from the data view into an Excel file. Alternatively, you can use DAX Studio to export if the file is too big to be just copy pasted (https://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax-studio-methods/)