Forum Discussion

mvhoffe's avatar
mvhoffe
Frequent Visitor
3 years ago
Solved

Summarizecolumns multiple tables (for export to excel)

Hello,   I have a challenge that I've been puzzling with for a long time. I would like your advice on this. I have a dataset containing a large number of tables that I also use for my visuals. My...
Need Help
  • smpa01's avatar
    smpa01
    3 years ago

    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.

     

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
3 years ago

4th 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).  

mahoneypat2

 

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.

mvhoffe's avatar
mvhoffe
Frequent Visitor
3 years ago

smpa01 thanks for reply,

 

I am going to watch the video and try the solution.

I know that excel has a limitation of 1,048,076 rows, but because i am summarize by product (and client) i only because I stay far below the 1 million lines, fortunately I don't suffer from that.