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

Anonymous，

What is version of your SSAS and what is the edition of the SQL Server instance?  Do you get same error when you connect to different SSAS databases?

Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

SSAS: 13.0.1601.5 (64 bit)

 

SQL Server: Microsoft SQL Server 2016 (RTM-GDR) (KB3179258) - 13.0.1711.0 (X64)   Jul 29 2016 16:16:44   Copyright (c) Microsoft Corporation  Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor) 

 

I created another database under the same ssas instance.  This database contains the same Tabular model I was trying to Import before without success.  However in this case I shrunk the fact table size to only 1K rows (whereas the original had 3.6M).  When I do 'Get Data' and 'Import' through Power BI Desktop it works fine.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    Based on your test, the issue is related to the size of your fact table size.

    I note that your SQL Server is RTM version, I would recommend you install SQL Server 2016 SP1 and latest CU for SP1, then check if the issue still occurs.

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for the response.  I will check with IT if the SQL Server can be updated and test it out again.

    • 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.