SSAS tabular model database fails to restore due to out of memory error

We have 2 customers getting an out of memory error when they backup or restore a large tabular model database. ¬ ¬† In the case of restoring a database backup, it is a 300GB .abf file restore on an SSAS server¬†with 1TB of memory. When all the files are extracted to the data folder, the…

1

Excel 2016 PowerPivot MDX query designer error

Problem: When you open Excel 2016, go to the Power Pivot tab, click the Mange button to bring up Power Pivot window In Power Pivot, click Get External Data, choose From Other Sources Choose Microsoft Analysis Services. Click Next Fill in the SSAS server name, then click Next, ¬† Click on the Design button, you…

18