Monday, February 11, 2013 10:43 PM
I am getting a strange error when creating Excel 2013 Power View sheets off an Analysis Services (SSAS) Tabular instance running on an Azure VM in the cloud. Here is the error:
Sorry, something went wrong while loading the model for the item or data source 'xxxxxx.cloudapp.net Tabular Model'. Verify that the connection information is correct and that you have permissions to access the data source.
The weird thing is that I can successfully create normal connected PivotTables from it; I only get the error when I try to make Power View sheets. Which would lead me to believe I am connecting to a multidimensional SSAS database, but I am not. Here are some things I have tried already:
Here are some details of my setup:
Update (2/12/2013): I installed Excel 2013 on the server and can successfully create Power View sheets connected to the Tabular database. This implies that my tabular SSAS instance is setup just fine, but the problem still exists when trying to create sheets through the internet.
Update (2/15/2013): I updated my Excel to 15.0.4454.1503 with Windows Update to no avail. I had a coworker successfully connect with a slightly older version of Excel 2013. I am totally stumped. I also attempted installing a fresh copy of Excel on a VM that I updated to v 15.0.4454.1503 and it was giving me the same error.