Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mlaiks
Frequent Visitor

cube seen as tabular - import power bi

Hi,

we cannot use our multidimensional cube in PBI Desktop because we cannot import it as a cube.

 

When importing the SSAS instance, normally, opening one of the database menu we can see only the cube object.

Now, after opening the db we find a folder, in which all measure groups and dimensions are listed and need to be selected all.

 

What could be the problem?


Thanks

2 ACCEPTED SOLUTIONS

@mlaiks

 

It seems you are using import mode. When connect live, it should be like this:

 

45.PNG

 

34.PNG

 

Regards,

View solution in original post

tannera
Advocate II
Advocate II

You aren't supposed to import a cube, you are supposed to live query it through a live connection. 

 

Importing it flattens the cube into a huge table, and would probably crash the server. 

View solution in original post

4 REPLIES 4
tannera
Advocate II
Advocate II

You aren't supposed to import a cube, you are supposed to live query it through a live connection. 

 

Importing it flattens the cube into a huge table, and would probably crash the server. 

Greg_Deckler
Super User
Super User

Can you just use a live (DirectQuery) connection?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Yes, we used a Live Connection, but we see as shown as belowUntitled.jpg

 

@mlaiks

 

It seems you are using import mode. When connect live, it should be like this:

 

45.PNG

 

34.PNG

 

Regards,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.