none
PowerView: Is it possible to connect SQL 2008R2 CUBE ?

    Question

  • We were just trying to explore PowerView; we have following environment:

    SharePoint 2010, PowerView, SQL Server 2008r2

    Problem is while I was trying to create connection for "SQL Server 2008r2 CUBE" for PowerView, connection is not getting establish but giving me following error:

    An error occurred while parsing the 'RequestType' element at line 7, column 55 ('urn:schemas-microsoft-com:xml-analysis' namespace) under Envelope/Body/Discover/RequestType. XML for Analysis parser: The 'DISCOVER_CSDL_METADATA' request type was not recognized by the server. ---> Microsoft.ReportingServices.DataExtensions.AdomdTestConnectionException: An error occurred while parsing the 'RequestType' element at line 7, column 55 ('urn:schemas-microsoft-com:xml-analysis' namespace) under Envelope/Body/Discover/RequestType. XML for Analysis parser: The 'DISCOVER_CSDL_METADATA' request type was not recognized by the server.

    I'm not sure about if for PowerView we can connect SQL Server 2008R2 Dimensional Databases or not; nor I'm finding much help regarding; It seems that PowerView supports SQL 2012 Dimensional databases only not previous versions.

    Please help...



    • Edited by Bhudev Wednesday, September 04, 2013 1:23 PM
    Wednesday, September 04, 2013 1:22 PM

Answers