Forum Discussion

mlaiks's avatar
mlaiks
Frequent Visitor
9 years ago
Solved

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...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    mlaiks

     

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

     

     

     

    Regards,

  • tannera's avatar
    tannera
    9 years ago

    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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Can you just use a live (DirectQuery) connection?

mlaiks's avatar
mlaiks
Frequent Visitor
9 years ago

Yes, we used a Live Connection, but we see as shown as below

 

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    mlaiks

     

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

     

     

     

    Regards,