The size of linked back tables cannot exceed the physical limit of 1M Tables and then loaded back in the model).
queries over the data model materialized in Excel You need a similar solution with Excel 2016, you can rely on linkedīack tables (i.e. Unfortunately, calculated tables are not available in Excel 2016. Please let me know if you need any further explanation to my answer. I personally used this approach, and has saved me tremendous time.
Using this tool, you will be able to load the same data set (table or other data source) and transform it as a separate table into the data model.
Until having the feature implemented by Microsoft, there is a good alternative within Excel ( versions from 2010 onward) by utilizing Get and Transform (called also PowerQuery in older versions). I personally believe Microsoft should consider this, given that DAX is efficient in data aggregation and analysis. As of now (August 2019), Excel does not support generation of calculated tables using DAX.
