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.
