Forum Discussion

Retha's avatar
Retha
Regular Visitor
8 years ago

objects missing with live connect to SSAS

I'm using live to connect to a multidimensional cube on SSAS, but not all my dimensions are visible. When I use import all of the missing one are available.

Why is that, and what can I do to add the missing objects?

Or am I missing something?

11 Replies

    • Retha's avatar
      Retha
      Regular Visitor
      8 years ago

      Had a look, but nothing there to explain why some dimensions (created the same way) are not pulling through with live

      • WolfBiber's avatar
        WolfBiber
        Microsoft Employee
        8 years ago

        Maybe a perspective or security Problem? 

        I have no trouble working with live connection and SSAS MD

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Retha，

    How about you use Excel to connect to SSAS? Do you get all dimensions?

    Regards,
    Lydia

    • Retha's avatar
      Retha
      Regular Visitor
      8 years ago

      Anonymous, yes I get all dimensions when I connect with Excel to SSAS. I even get all testing with import. It is just with live that I'm experiencing the issue.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Retha,

        Do you use the latest version of Power BI Desktop(2.52.4921.682 )?If so, clear cache in Power BI Desktop and check if the issue still occurs.


        If the issue persists, I recommend you reboot machine, re-install Power BI Desktop.

        Regards,
        Lydia