Forum Discussion

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 27, 2019

Hi txrussianguy ,

 

In general Excel is not SQL tool, you may use SQL query in connectors to SQL databases. In Excel to transform data is used Power Query, it has its own M-script language and rich user interface. I many cases only UI is enough to transform data, in particular transformations as you say could be done within it. Result is returned back to Excel sheet as Excel table.

 

Data model (Power Pivot and DAX language) if you'd like to add any measures and return result back as PivotTable (however, could be also Excel table).

 

Not sure about file size, don't think you reduce it compare with PivotTables only, especially if you don't save PivotTable cache within the file.

txrussianguy's avatar
txrussianguy
Brass Contributor
Mar 27, 2019

SergeiBaklanthanks very much.  I never save cache on pivots, and figured that this might be my easier near-term solution. 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 27, 2019

    txrussianguy , yes, if you uncheck this default setting file size could be reduced significantly