Stack Overflow
Stack Overflow

Questions tagged [powerview]

Power View is a visualisation and prototyping tool created by Microsoft and released as part of SQL Server 2012.

Power View was designed to bring visualisation and analysis capability to end-users, rather than relying on specialised database/business intelligence developers to create reports.

It is based on Microsoft's existing SSRS technology and hosted via SharePoint 2010. PowerView reports are constructed on top of pre-existing data models built using either PowerPivot or the new SSAS Tabular model.

Power View itself presents users with a Silverlight front-end, allowing quick drag and drop functionality to build charts, tables and other visualisations in a matter of seconds. The data structure is exposed in an almost identical manner to Excel's PivotTable/PivotChart functionality.

The initial release of Power View requires SharePoint 2010 as a host for both the Power View and the underlying data model, although Office 2013 also includes built-in Power View capability, using a more advanced version of the tool. Power View reports can also be exported from SharePoint into PowerPoint presentations, and manipulate data live therein.

Further Reading

104 questions
0
votes
0 answers

Export, Publish or Deploy Power View to SharePoint on Premise NOT AVAILABLE ?!

I have just finished working on a Power View Report in Excel 2013, so i thought ok, now that this is done I can simply Publish it to my SharePoint Power View Gallery, must be pretty simple right, after all It could only be intuitively assumed that…
gberisha
  • 291
  • 5
  • 17
0
votes
1 answer

I can't add coordinates attributes in Power View

Currently I'm trying to add my coordinates attributes to the latitude and longitude field of power view but power view doesn't let me add the attributes to the fields. Both attribute data type in the dimension is double. The data comes from a…
Roberto Durand
  • 137
  • 1
  • 1
  • 13
0
votes
1 answer

Get PowerView to work with existing cubes on SQL Server 2008 R2

I've been doing some research into the setup required to get PowerView to connect to existing cubes sitting on a SQL Server 2008 R2 instance. Can anyone confirm that the following is right (or correct me if I'm wrong)? I believe I need the…
hello-klol
  • 735
  • 10
  • 20
0
votes
1 answer

Weighted Averages in PowerView

My objective is to create a weighted average of price where the weights depend on the value of size per category, using the PowerView functionality in Excel 2013. For instance the following table: Table Category Price Size 1 10 …
user3071288
  • 1
0
votes
1 answer

Power View Add in

I'm trying to use Power View from Excel 2013 so I tried to enable the Power View Add in. I followed steps to enable Power View add-in in excel 2013 , but after opening COM Add-ins option in Excel , i couldn't find "Power View " option. So the…
Sally El-Sayed
  • 161
  • 1
  • 5
  • 11
0
votes
1 answer

Excel Power View and SharePoint and filtering

Sharepoint Online (O365 E3 Plan) and Excel 2013. Hi, I created Power View in excel using data from our CRM. I exported data from our CRM, created a PowerPivot table from the data, run a few functions and from there created a Power View Sheet. From…
Haz
  • 1
  • 1
0
votes
0 answers

PowerView Security in SharePoint 2013

I have made a PowerView report in which I have shown data for all regions (for instance, East, West, Central). I have created a cube role so that User can only see data for region 'Central'. I have also enabled the EffectiveUserName" property in…
Jessica Yoskovich
  • 41
  • 7
0
votes
1 answer

Maps in Excel Power View

I have an analysis service implementation for my data in SQL SERVER 2012. Now I want to create a geographic (map) report for my data in Excel power view reports. When I add all my data in the report and click the map icon, it states that "The map…
Prabhanjan Kumar Mahapatra
  • 589
  • 1
  • 9
  • 23
0
votes
1 answer

Using Power View in SSRS

Is it required to have SharePoint server for working with Power View in SSRS? I have SQL Server with MSBI 2012. My client is inclined towards using Power view. Do I need need to install SharePoint (and pay for it) to use Power view in SSRS with SQL…
Sandip
  • 1
  • 1
0
votes
2 answers

Can Power View be viewed on the iPhone or iPad?

And if not, are there plans to provide support in the future (using HTML5/Canvas or other technology)? This could be a deal-breaker for us.
Gabe
  • 5,113
  • 11
  • 55
  • 88
0
votes
1 answer

Power View Fails to Connect

When I try to create a Pover View report over my .bism connection I get following error: Original XML rsCannotRetrieveModel400An error occurred while loading the model for the item or data source 'http://localhost/rpl/model.bism'. Verify that…
user1584160
  • 1
  • 1
  • 2
-1
votes
1 answer

DirectoryEntry (0x80005000)

string strPath = "LDAP://" + dcip; DirectoryEntry de; if (String.IsNullOrEmpty(username)) { de = new DirectoryEntry(strPath); } else { de = new DirectoryEntry(strPath,…
Szz9527
  • 1
  • 1
-1
votes
1 answer

How to visualise a SQL Server view using powerView in Excel?

I'm new to data visualisation and powerview etc. but I have the following view in SQL Server: --This view displays any delivery that was late and by how many days CREATE VIEW [Display Late Deliveries] AS --Wrapped into subquery to allow the filter…
oCyrusTheVirus
  • 1
  • 2
-3
votes
1 answer

Map multiple people in multiple States

I am looking for a way to chart out some Excel data onto a PowerView map. I'd like to see which person within my group is most active in each state. However, when I'm running with the data in Excel and PowerView, it lists every person and their…
tacodestroyer
  • 19
  • 6
1 2 3 4 5 6
7