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 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

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. 

4 Replies

    • 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,

  • tannera's avatar
    tannera
    Icon for Advocate II rankAdvocate II
    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.