Getting the Most
out of Microsoft
6 tips, as well as some recent enhancements
is a technology specialist for
Microsoft, helping customers
evaluate and adopt
intelligence (BI) platform.
He’s the author of the book
Understanding the United
States Debt (CreateSpace).
Microsoft Power View was introduced as part of SQL Server 2012. I’ll provide you with six tips for getting the most of out of Power View. I’ll also highlight some of the recent
enhancements made to Power View in SQL Server 2012 SP1. (If you’re
unfamiliar with Power View, see “Introducing Microsoft Power View”
for more information.)
Tip 1: How to Easily Connect to Power View
Power View reports use a business-friendly data source, which is either
a PowerPivot workbook or a SQL Server Analysis Services (SSAS) database in tabular mode. An easy way to start using Power View is to
click a PowerPivot workbook’s Power View icon within a PowerPivot
Gallery, as Figure 1 shows. Power View can also be launched by clicking a Report Data Source (RDS) file or a Business Intelligence Semantic
Model (BISM) file. Typically, these files are published to a SharePoint
data connection library.
Setting up a BISM connection is pretty straightforward. An RDS file
can be used in place of a BISM file in situations where you want to
customize the connection string or credentials used to connect to the