cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hiteshpatel1983 Regular Visitor
Regular Visitor

Cannot connect live SSAS SQL 2012 SP2 CU4 MD Enterprise

Hi,

 

I am investigating a situation where I am trying to connect to SSAS MD cube using live connect in my Power BI desktop. The tricky part to this is that I am able to connect to the cube on the server but it won't load any dimensions/measure groups in the Filter area of a Power BI desktop file and it would just show the loading icon in the Filter area.

 

The details of the versions are - 

  • Power BI Desktop - Version: 2.50.4859.502 64-bit (September 2017)
  • SQL Server Analysis Services 2012 SP2 CU4 (11.0.5569.0) MD (Enterprise Edition)
  • Connecting to the cube over https (using a msmdpump)

 

Has anyone come across such an issue for the above version of SSAS MD? If so, what's the resolution to this?

 

It works fine for me when I connect to a cube on SSAS 2016.

 

Thanks,

Hitesh

3 REPLIES 3
Moderator v-sihou-msft
Moderator

Re: Cannot connect live SSAS SQL 2012 SP2 CU4 MD Enterprise

@hiteshpatel1983

 

As confirmed with Product Team, the DataPump connection for SSAS is not supported today. So don't use http access to connect SSAS data source.

 

Regards,

hiteshpatel1983 Regular Visitor
Regular Visitor

Re: Cannot connect live SSAS SQL 2012 SP2 CU4 MD Enterprise

Hi Simon,

 

Thanks for your prompt reply. 

 

If DataPump connections are not supported, how do we (our clients) connnect to the cubes that are not necessarily in their domain?

 

Do you know any workarounds or point me to any post/discussions around this?

 

Thanks,

Hitesh

rsfurlan90 Frequent Visitor
Frequent Visitor

Re: Cannot connect live SSAS SQL 2012 SP2 CU4 MD Enterprise

Any news on that? Are there plans to support DataPump on a live connection?

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 399 members 3,775 guests
Please welcome our newest community members: