PowerView of Excel2013 not working on "Power View for Multidimensional Models CTP"

PowerView of Excel2013 not working on "Power View for Multidimensional Models CTP" by Gerhard Brueckl

Active

Type:	Bug
ID:	774866
Opened:	12/20/2012 6:42:15 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

The SQL Server Build "Power View for Multidimensional Models CTP" supports DAX on multidimensional models. However it is not possible to connect PowerView of Excel2013 to a mutlidimensional model hosted in the new build.
As DAX is now supported it should also support PowerView of Excel2013.

Details (expand)

English

private build - 11.0.9000.5

Analysis Services

Windows 7 Professional (SP1)

English

1) Host a multidimensional model in the new SQL Server Build "Power View for Multidimensional Models CTP" (SSAS Multidimensional Instance)
2) Use PowerPivot of Excel 2013 to connect to the model

Excel throws an error message saying that an error accured while connecting to the datasource.
SQL Profiler reveals further information - the error comes from an XMLA-Discover command:
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">

    <RequestType>DISCOVER_CSDL_METADATA</RequestType>

    <Restrictions>
        <RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis">
            <CATALOG_NAME>Adventure Works DW 2008R2</CATALOG_NAME>
            <PERSPECTIVE_NAME>Adventure Works</PERSPECTIVE_NAME>
            <VERSION>1.1</VERSION>
        </RestrictionList>
    </Restrictions>

    <Properties>
        <PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis">
            <Catalog>Adventure Works DW 2008R2</Catalog>
            <LocaleIdentifier>3079</LocaleIdentifier>
            <Content>SchemaData</Content>
            <Format>Tabular</Format>
            <DbpropMsmdActivityID>998189db-36cd-4e49-bd78-894423089a42</DbpropMsmdActivityID>
            <DbpropMsmdRequestID>d1c69b46-eb34-40fb-a25f-fc14bd7d66b3</DbpropMsmdRequestID>
        </PropertyList>
    </Properties>
</Discover>

this XMLA results in the following error message:
Error in the metadata manager. The current model can only be expressed when the client is requesting tabular view metadata with VERSION restriction of 2.0 or later.

Compared to an Analysis Server 2012 SP1 running in tabular mode the same XMLA works and so also PowerView works. This indicates that the problem is related to the the new build and not to PowerView itself

PowerView of Excel 2013 should work on the "Power View for Multidimensional Models CTP" Build

X64

File Name	Submitted By	Submitted On	File Size
CTP_Query3.xmla	Gerhard Brueckl	12/20/2012	840 bytes

Hello,

Thank you for the feedback. Power View in SharePoint mode is the only option supported against multidimensional model as part of this CTP. We will consider your request for a future release.

Regards
Siva