Solving security issue in PowerPivot for SharePoint and Power View

Posted by Marco Russo (SQLBI) on SQL Blog See other posts from SQL Blog or by Marco Russo (SQLBI)
Published on Fri, 18 Nov 2011 22:26:52 GMT Indexed on 2011/11/19 2:02 UTC
Read the original article Hit count: 289

Filed under:

PowePivot

I just installed a brand new server (well, a virtual machine) with SharePoint 2010 SP1 and SQL Server 2012 RC0, including PowerPivot and Reporting Services / Power View. The server is joined to the domain I use in our development environment. I published a workbook in the PowerPivot Gallery and my user was immediately able to connect, browse and navigate data of the Excel workbook published by SharePoint. Moreover, I was able to open it in Power View. However, other users failed the connection. After...(read more)

Related posts about PowePivot

Optimize SUMMARIZE with ADDCOLUMNS in Dax #ssas #tabular #dax #powerpivot

as seen on SQL Blog - Search for 'SQL Blog'
If you started using DAX as a query language, you might have encountered some performance issues by using SUMMARIZE. The problem is related to the calculation you put in the SUMMARIZE, by adding what are called extension columns, which compute their value within a filter context defined by the rows… >>> More
DATE function does not support all the dates in DAX by design #powerpivot #tabular #dax

as seen on SQL Blog - Search for 'SQL Blog'
The DATE function in DAX has this simple syntax: DATE( <year>, <month>, <day> ) If you are like me, you never read the BOL notes that says in a clear way that it supports dates beginning with March 1, 1900. In fact, I was wrongly assuming that it would have supported any date that… >>> More
Analysis Services Tabular books #ssas #tabular

as seen on SQL Blog - Search for 'SQL Blog'
Many people are looking for books about Analysis Services Tabular. Today there are two books available and they complement each other: Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model by Marco Russo, Alberto Ferrari and Chris Webb Applied Microsoft SQL Server 2012 Analysis… >>> More
#PowerPivot Workshop Online for America’s Time Zones #ppws

as seen on SQL Blog - Search for 'SQL Blog'
After so many request we have finally arranged a PowerPivot Workshop online edition dedicated to America’s time zones! It is scheduled for December 19-20, 2012, with this schedule: US Eastern Time (EST): 10:00am-1:00pm / 2:00pm-5:00pm US Central Time (CST): 9:00am-12:00pm / 1:00pm-4:00pm US Pacific… >>> More
A new SQL, a new Analysis Services, a new Workshop! #ssas #sql2012

as seen on SQL Blog - Search for 'SQL Blog'
One week ago Microsoft SQL Server 2012 finally debuted with a virtual launch event and you can find many intro sessions there (20 minutes each). There is a lot of new content available if you want to learn more about SQL 2012 and in this blog post I’d like to provide a few link to sessions, documents… >>> More

Developer IT