Create PowerView Report Error DAX not supported
I have installed powerpivot for sharepoint & reporting services add-in sharepoint successfully i use excel 2010 powerpivot connected ssas cube data source and save the file to sharepoint powerpivot libary the sharepoint user same as ssas cube user when i click create powerview report i got the following error: an error occurred while loading the model for the item or datasourcehttp://...xlsx verify that the connection information is correct and that you ave prmissions to access the data source. Error Details: <detail><ErrorCode xmlns="rsCannotRetrieveModel</ErrorCode><HttpStatus">http://www.microsoft.com/sql/reportingservices">rsCannotRetrieveModel</ErrorCode><HttpStatus xmlns="400</HttpStatus><Message">http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="An">http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://ssavn1331/PowerPivot/Saic.xlsx'. Verify that the connection information is correct and that you have permissions to access the data source.</Message><HelpLink xmlns="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsCannotRetrieveModel&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.2100.60</HelpLink><ProductName">http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.2100.60</HelpLink><ProductName xmlns="Microsoft">http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="11.0.2100.60</ProductVersion><ProductLocaleId">http://www.microsoft.com/sql/reportingservices">11.0.2100.60</ProductVersion><ProductLocaleId xmlns="127</ProductLocaleId><OperatingSystem">http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="OsIndependent</OperatingSystem><CountryLocaleId">http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="1033</CountryLocaleId><MoreInformation">http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="<Source>ReportingServicesLibrary</Source><Message">http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsCannotRetrieveModel" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.2100.60" xmlns:msrs="An">http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://ssavn1331/PowerPivot/Saic.xlsx'. Verify that the connection information is correct and that you have permissions to access the data source.</Message><MoreInformation><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsDataExtensionNotFound" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsDataExtensionNotFound&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=1.0" xmlns:msrs="An">http://www.microsoft.com/sql/reportingservices">An attempt has been made to use a data extension 'DAX' that is either not registered for this report server or is not supported in this edition of Reporting Services.</Message></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail> thx very much for your kindly reply.
August 28th, 2012 7:17am

Hi kael.thas, Sorry for the delay. To use the Power View feature, the SQL Server 2012 must be Standard/BI/Enterprise Edition, and the SharePoint must be Enterprise Edition. Please make sure your currently installed SQL Server and SharePoint support Power View. If your current envrionemt supports Power View, the error message "An attempt has been made to use a data extension 'DAX' that is either not registered for this report server or is not supported in this edition of Reporting Services" may occur if the PowerPivot for Excel add-in was not installed correctly. To download and install PowerPivot for Excel, please follow the article below: PowerPivot for Excel Installation Hope this helps. Regards, Mike YinMike Yin TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
September 4th, 2012 4:29am

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

Other recent topics Other recent topics