Forum Discussion

fmasselink's avatar
fmasselink
Regular Visitor
4 years ago

Create lookup table from source data

Hello,   For some I've been trying and struggling with the following dilemma.   The below is an oversimplified version of my real PowerBI report.  The real source is > 100GB of csv files. The cu...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

fmasselink , I think DAX summarize can be good option in this case, In case you have not tried. Please try that

  • fmasselink's avatar
    fmasselink
    Regular Visitor
    4 years ago

    amitchandak thank you for the swift reply. Would that also decrease the overall size of the resulting report?

    Wouldn't DAX Summarize merely create an extra table/view? It would not delete the information from the original table?
    Reducing the size of my report is the primary goal.

    I used Grouping in PowerQuery, though instead of ~8 hours to read the data it took > 48 hours. So l'm looking at better ways.