At this point in time, does Power View in Excel have the ability to connect directly to an Analysis Services multidimensional cube?

If not, is this functionality expected in the near future?

Hi,

As far as I known, the Power View for Excel does not support the feature yet, please see this article:

https://msdn.microsoft.com/en-us/library/jj969574.aspx

I copied part of the article here:

Native support for Power View            

With this release, multidimensional models support analysis and visualization by using Power View in SharePoint mode. No special configuration of your multidimensional models is necessary. There are however some differences in how multidimensional model objects are displayed in Power View compared to other client tools such as Microsoft Excel and Microsoft Performance Point. This release does not support analysis and visualization of multidimensional models by using Power View in Excel 2013.

====

We may use Power View for SQL Server 2014. For more detail information, please refer to the following link:

http://blogs.msdn.com/b/user_ed/archive/2014/01/02/business-intelligence-in-sql-server-2014-power-view-for-multidimensional-models.aspx

Hope it's helpful.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Tuesday, February 03, 2015 1:18 AM
• Unproposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Tuesday, February 03, 2015 1:22 AM
• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Thursday, February 05, 2015 7:08 AM
• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 5 hours 13 minutes ago

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, January 30, 2015 3:05 AM

Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"