Databases
StackOverflow2013
Postsdbo
POError Creating Power View sheets from SSAS Tabular
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError Creating Power View sheets from SSAS Tabular
    primarykey
    data
    text
    <p>I am getting a strange error when creating Excel 2013 Power View sheets off an Analysis Services (SSAS) <strong>Tabular</strong> instance running on an Azure VM in the cloud. Here is the error:</p> <blockquote> <p>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.</p> </blockquote> <p>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:</p> <ul> <li>Forwarded the default SSAS port 2383 in Azure and opened it in windows firewall (this allowed me to browse the cube with connected PivotTables)</li> <li>Ensured my login has permissions on the SSAS database (I am <strong>not</strong> using windows authentication)</li> <li>Checked the SSAS Tabular compatability version, it is 1103</li> <li>Checked the SSAS Tabular SSDT project compatability level, it is also 1103</li> <li>Made sure SQL Server Browser was running (I read somewhere that might be an issue)</li> <li>Tried opening port 80 and 443 in case those were needed for something, didn't help...</li> <li>Tried monitoring Excel's port usage to see if it was trying other ports, couldn't see anything besides 2383</li> <li>Sucessfully connected to an intranet SSAS Tabular database (comparability 1101) and created a Power View sheet from it (which means there shouldn't be anything wrong with my Excel client)</li> </ul> <p>Here are some details of my setup:</p> <h3>Server</h3> <ul> <li>Windows Server 2012</li> <li>SQL Server 2012 SP1</li> <li>SSAS Tabular default instance (compatability level 1103)</li> </ul> <h3>Client</h3> <ul> <li>Windows 8</li> <li>Excel 2013 (15.0.4426.1017) MSO (15.0.4454.1002) 32-bit</li> </ul> <p><strong>Update (2/12/2013):</strong> 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.</p> <p><strong>Update (2/15/2013):</strong> 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.</p> <p><strong>Update (2/20/2013):</strong> I installed a fresh <em>local</em> VM with Windows Server 2012, SQL Server 2012, and SSAS Tabular compat 1103. I STILL cannot successfully make Power View reports from that server. I <strong>strongly</strong> believe there is some kind of bug with the Excel 2013 client.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJondlm
    1. USJondlm
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POError Creating Power View sheets from SSAS Tabular
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POError Creating Power View sheets from SSAS Tabular
      1. USHenri
      1. VTFavorite
    3. VO
      singulars
      1. POError Creating Power View sheets from SSAS Tabular
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI got the same problem...
      singulars
      1. POError Creating Power View sheets from SSAS Tabular
      1. USHenri
    2. COGlad to hear I'm not alone! I posted the same problem to the SSAS forums and haven't heard back there yet either.
      singulars
      1. POError Creating Power View sheets from SSAS Tabular
      1. USJondlm
    3. COAny news with this one?
      singulars
      1. POError Creating Power View sheets from SSAS Tabular
      1. USHenri
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload