Accessing Analysis Services MultiDimensional cube data with Power View in Excel

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?

January 26th, 2015 8:21pm

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"



Free Windows Admin Tool Kit Click here and download it now
January 27th, 2015 4:29am


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"
January 30th, 2015 6:05am

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"

Free Windows Admin Tool Kit Click here and download it now
February 6th, 2015 1:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics