Forum Discussion
Summarizecolumns multiple tables (for export to excel)
The problem is how to merge the different fields from the 4 tables without big performance loss - make sure you have a datamodel that speaks to that business req, optimize dax measures and you should be good.
Community Champion4th option if you are on premium workspace and access to Power automate (default ENV will do, you don't need premium) , you can called DAX API by following this video from Ruth which will loop though all the lines and bypass 100k limit to generate the 2mil+ row report in fragmentation.
Once the flow runs you can pick up the pieces from the folder and sew them to a CSV (I hope I am right).
mvhoffe BTW excel has limitation of excel limitation of 1,048,576 rows by 16,384 columns, So you can't filt 2mil+ row in an excel.
sorry smpa01 .
This is a nice solution to export 1 table to csv/excel. That is not the problem (i can do this also with Dax studio ?).
The problem is how to merge the different fields from the 4 tables without big performance loss. And then export this to excel/csv.
- smpa01
The problem is how to merge the different fields from the 4 tables without big performance loss - make sure you have a datamodel that speaks to that business req, optimize dax measures and you should be good.