Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Import SSAS Tabular Database: Unexpected Exception

I have a SSAS Tabular database on premise.  I try to Import this database into PowerBI Desktop, however, whenever I select one of the tables in this database I get Unexpected Exception occurred as an...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

We've updated the SQL Server as follows:

 

SQL Server: Microsoft SQL Server 2016 (SP1-CU6) (KB4037354) - 13.0.4457.0 (X64)   Nov  8 2017 17:32:23

 

SSAS: 13.0.4457.0

 

The Size of the source database in SQL Server is: 2.4 GB (MDF File), 4.6 GB (LDF File)

 

The Size of the database in SSAS Server (the Tabular Cube) is 283 MB.  I get this by right clicking on the databse in SSAS then selecting Reports-->Standard Reports-->General

 

My computer has 8GB of RAM and at the time I try to Import the SSAS cube in Power BI Desktop I have about 4 GB of free RAM.

 

The error message I am getting now is below.  Note that We are already using the 64 bit version of the product and the latest November 2017 update.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks, it's not clear though from the thread which of the memory settings resolved the issue and there are several of them.  I've included a screen shot of the Memory Related settings on the SSAS instance.  I did make changes to some of them but the memory related error is still coming up.  the screen shot has the deafult settings.  Can you please let me know which of the settings would likely require modifications?