Forum Discussion

RMDNA's avatar
RMDNA
Solution Sage
9 years ago

Connecting to Cube - model tables and unique values

Hi all,   I'm connecting to a cube, and I'm running into a couple issues.   1. When I'm importing data from the cube in the navigator, I get to the 26 tables in the model. If I select multiple ta...
Need Help
Rvn86's avatar
Rvn86
Helper I
9 years ago

Hi.

 

I see this is an old thread, but I am experiencing a similar issue.

 

You cannot create a live connection if you do not have a SQL-server version where live connection to PBI is supported. 

 

I have created a relatively complex multidimensional cube, which is built on DW views with data I have extracted from Dynamics AX. I am able to create most relationships manually (even though it is a time consuming task), but I am struggling witht he financial dimensions from Dynamics AX, since there are no direct ID's for the dimensions to the other views I want to link them to.

 

Are the no possibility to keep the relationships when importing from a multidimensional cube? Any tips here to make the process as smooth as possible? Or is the solution as simple as doing a server upgrade to an enterprise version to support live connection?

 

Thank you.

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Are the no possibility to keep the relationships when importing from a multidimensional cube? Any tips here to make the process as smooth as possible? Or is the solution as simple as doing a server upgrade to an enterprise version to support live connection?

 

Hi Rvn86,

 

It's not supported, all defined relationships in cube will lose after you import SSAS data. You need to create it again. Or upgrade SQL Server to SQL Server 2012 SP1 CU4 or later version.

 

Best Regards,
Qiuyun Yu

 

 

  • Rvn86's avatar
    Rvn86
    Helper I
    9 years ago

    Too bad, but that's life... 

     

    Thank you for a fast reply.