Forum Discussion

emmaclarke83's avatar
emmaclarke83
Helper I
8 years ago

connection to a cube

I have been able to connect to a cube in Excel using MSOLAP.5 provider and it works perfectly.  I have been trying to connect to the same cube using the datasource SQL Server Analylsis Services but I am getting the error:

 

unable to connect
we encountered an error while trying to connect
details: "AnalysisServices: object reference not set to an instance of an object

 

Can anyone suggest a solution ?

 

Thanks

Need Help

7 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    8 years ago

    emmaclarke83

     

    Did you configure HTTP Access to SSAS cube? 

     

    Currently, HTTP Access is not supported for connecting SSAS in Power BI Desktop. 

     

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      This is critical for us. Why was this feature removed and when will it be added back?

    • Moorest's avatar
      Moorest
      Frequent Visitor
      8 years ago

      Was this feature removed in the latest versions of BI? it works in the June version.

       

      And do you know when it will be added back in?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi! I'm still looking into this. What's the Status of this?

  • ryangiesen's avatar
    ryangiesen
    Regular Visitor
    8 years ago

    I am looking to do the same thing.  I think this is the only way I can connect to NICE InContact data, but it does not currently work.  Would love to know if anyone was able to find a workaround.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Well i heard from the support team, apparently this feature was never supposed to work hence now that its broken, they are not going to fix it !!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Did you ever figure out how to get to your incontact DDA data in Power BI?