SSRS with SSAS – Message with no host or could not find host in AX 2012

Step 1

Check if host used in OLAP data source exists and there are correct permissions to connect to the host for SSRS and BI users.

Step 2

Sometimes you will need to change host in OLAP data source. To fix it:

• Open Microsoft Dynamics AX Management Shell.
• Run command: Get-AXReportDataSource -DataSourceName DynamicsAXOLAP| format-list
• Copy the string from “ConnectionString”, change value in property “Data Source=” to your correct SSASServerNme\SSASNamedInstance and run the command: Set-AXReportDataSource -ConnectionString “<ConnectionString>” -DataSourceName DynamicsAXOLAP
• Redeploy reports to SSRS.