Forum Discussion

mchapman's avatar
mchapman
Icon for Advocate I rankAdvocate I
2 years ago
Solved

XMLA Endpoint connection to online SSAS multidimensional semantic model from Excel

I have many SSAS MD cubes that have semantic models published to power bi workspaces. The cubes are connected live via a data gateway to on-prem SSAS MD Cubes. I have tried connecting to these via excel but since they workspaces are set up to look like tabular instances, is there anything I can do to get a coneection to an MD cube working.

Need Help
  • GilbertQ's avatar
    GilbertQ
    2 years ago

    Hi mchapman Unfortunately, it is not possible to connect via the power BI service to a multidimensional cubes. You will have to connect directly to the cube, which you'll then have to open up to the Internet.

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    2 years ago

    Hi mchapman Unfortunately, it is not possible to connect via the power BI service to a multidimensional cubes. You will have to connect directly to the cube, which you'll then have to open up to the Internet.

    • mchapman's avatar
      mchapman
      Icon for Advocate I rankAdvocate I
      2 years ago

      That's too bad I was really hoping they were going to open it up for MD cubes. We're starting to think the only way to keep the hackers our of our network is to keep our people out too.  This would have been a big step in that direction

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        2 years ago

        haha fair enough, if you have got the right authentication in place I find the data is secure in the Power BI Service.