Connect to SSAS tabular model hosted on azure VM via excel powerview

Question

I'm having an issue connecting to a SSAS tabular model directly from excel when creating a powerview sheet. Trying to do this gives me the typical "Sorry, something went wrong while loading the model for the item or data source..."

Interestingly, the same tabular model and connection string works if i select PivotTable (rather than PowerView report) in excel which indicates that the connection is at least possible and SSAS is configured correctly? I'm at a loss at this point as to why this could be happening - is it a bug in PowerView? Is it a known issue?

Answer 1

Power View in Excel 2013 only connects to embedded Power Pivot models. Connection to SSAS Tabular is still not supported in Excel 2013 SP1 (unfortunately).

---

Marco Russo http://www.sqlbi.com http://www.powerpivotworkshop.com http://sqlblog.com/blogs/marco_russo

Answer 2

That can't be right - it works on my localhost!

This link explicitly mentions connecting excel 2013 to a tabular model in ssas:

http://office.microsoft.com/en-au/excel-help/create-a-power-view-sheet-connected-to-an-external-data-model-in-excel-HA103230578.aspx?CTT=5&origin=HA102899553

Answer 3

Sorry you're right - I was thinking to DAXMD support (DAX over Multidimensional).

Which SSAS version (build) do you have on the server?

---

Marco Russo http://www.sqlbi.com http://www.powerpivotworkshop.com http://sqlblog.com/blogs/marco_russo

Answer 4

Hi Icon1234,

According to your description, you cannot create a PowerView worksheet to connect to SQL Server Analysis Services tabular mode hosted on azure VM, right? For the error message "Sorry, something went wrong while loading the model for the item or data source", it seems this is a bug in PowerView. Here is a similar issue, and cannot solve it with many ties.
http://www.codeasking.com/2568488/error-creating-power-view-sheets-from-ssas-tabular.html

You can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation.

Regards,
Charlie Liao

If you have any feedback on our support, please click here.

---

Charlie Liao
TechNet Community Support