I get a weird error when creating Excel Power Power View worksheets from an Analysis Services (SSAS) Tabular instance running on an Azure VM in the cloud. Here is the error:
Sorry, something went wrong when loading the model for the item or data source "xxxxxx.cloudapp.net Tableular Model". Verify that the connection information is correct and that you have permissions to access the data source.
The strange thing is that I can successfully create regular pivot tables from it; I get an error when I try to make Power View sheets. Which would make me think that I am connecting to a multi-dimensional SSAS database, but I am not. Here are a few things I've already tried:
- Forwarded the default port 2383 SSAS in Azure and opened it in the Windows firewall (this allowed me to view the cube with connected pivot tables).
- Make sure my login has permissions in the SSAS database (I'm not using Windows Authentication)
- Checked compatibility version with SSAS table, it is 1103
- Checked the compatibility level of the SSAS Tableular SSDT project, it is also 1103
- Make sure SQL Server Browser is running (I read somewhere that might be the problem)
- I tried to open port 80 and 443 in case they were needed for something, they didn’t help ...
- I tried to track the use of the Excel port to check if it tried to use other ports, did not see anything except 2383
- SSAS Intranet ( 1101) Power View ( , Excel )
:
- Windows Server 2012
- SQL Server 2012 SP1
- SSAS ( 1103)
Client
- Windows 8
- Excel 2013 (15.0.4426.1017) MSO (15.0.4454.1002) 32-
(2/12/2013): Excel 2013 Power View, Tabular. , SSAS , .
(2/15/2013): Excel 15.0.4454.1503 Windows . , Excel 2013 . . Excel , 15.0.4454.1503, .
(2/20/2013): Windows Server 2012, SQL Server 2012 SSAS Tabular compat 1103. STILL Power View . , Excel 2013.