Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Import in PowerBI from OLAP Cube with Java heap space error

Currently I'm trying to connect PowerBI to the Financial OLAP Database of the planning- and reporting software Lucanet.

 

All I'm doing is:

  -Choosing a connection to SQL Server Analysis Database

  -Enter credentials to OLAP Cube and choose option import (instead of live query (currently not possible at our company))

  -After the connection is established I select all 7 levels of the Cube plus the measures themselves (I know that it's possibly too much data selected but I need all levels of the Cube in my PowerBI file)

 

During the last two attempts I

  -Tried to just load the data without any transformation --> After a couple of seconds the Lucanet server broke down and it had to be restarted

  -Clicked on the the data transformation menu --> No response, after some seconds I received a Java heap space error and the Lucanet Server broke down again

 

Anybody with an advice to me how I can tackle this problem?

 

Thanks in advance

 

 

--- EDIT ---

 

Together with the Lucanet Support I figured out, that it is currently not possible to connect PowerBI to the OLAP Cube of Lucanet.

It is necessary to export the Data from the OLAP Cube in a separate Warehouse to access the it.

1 Reply

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support

    Hi Anonymous ,

     

    You could creat a support ticket with your problem.

     

    Best Regards,

    Liang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.