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&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsCannotRetrieveModel&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&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&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsCannotRetrieveModel&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&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&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsDataExtensionNotFound&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&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