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
1 answer

Total Messages vs. Day & Hour in Power view chart

Table-1 has: Date                                         Number of Msgs 05-01-2015 12:45:26                      2 06-01-2015 16:48:00                      4 07-01-2015 10:15:25                      …
user4365170
0
votes
1 answer

powerview in sharepoint 2013 app

We got a requirement to embed powerview graphs and powerpivot tables in sharepoint 2013 app. I am new to sharepoint app development. Please direct me with some reference articles. Thanks MM
Maddy
  • 55
  • 1
  • 8
0
votes
1 answer

Access to bing maps via Excel 2013 with PowerView blocked by fw

Here is my problem. I have a client that uses the plug-in powerview through Excel2013 . At the beginning my client hadn't at all access as our firewall was blocking the access to the office365 IP and Bing.com. Once the flow authorized on the…
nicolas
  • 3
  • 3
0
votes
1 answer

Powerview drop filter context on a column

I'm currently working on a power view project where I need to display the numbers of the gross market and compare these to the numbers of a certain customer. In this particular example, the market has sales in clothing, food, entertainment and…
Neglexis
  • 111
  • 1
  • 1
  • 12
0
votes
1 answer

PowerView not showing date measure

I have an SSAS tabular model where I define a measure like so: EndDate := LASTDATE(myTable[Date]) I can see and use this measure in Excel and in SSMS, however it does not appear in the field list in PowerView. I know of a workaround like the…
Kyle Weller
  • 2,533
  • 9
  • 35
  • 45
0
votes
1 answer

DAX - selecting rows with partial match

I have a powerpivot table that contains 2 columns: Column 1 contains strings. Column 2 contains comma delimited strings. I would like to be able to display all the rows from column 1 when rows from column 2 contains the selection from a filter or…
user1238760
  • 61
  • 2
  • 6
0
votes
1 answer

PowerView automatically aggregating data

I have several fields in a SQL Server Table that are Integer but are labels. When I try to bring the data into PowerView for Excel it automatically aggregates these numbers and gives me an aggregate with a Sigma showing they are a sum. How do you…
SASUSMC
  • 681
  • 4
  • 20
  • 38
0
votes
1 answer

PowerPivot - How to calculate trend by comparing two periods?

I'would like to create a KPI to compare results from two periods. My data source looks like the following example : User | NB sales | Date Bob | 10 | 01/01/2014 Tim | 20 | 01/01/2014 Bob | 5 | 01/02/2014 ... So I would like to…
K4timini
  • 711
  • 2
  • 14
  • 34
0
votes
1 answer

PowerPivot - How to grab data from Yahoo webservices

I would like to import weather forecasts in PowerPivot for a specified country by using Yahoo API. So first of all I got the data stream URL including all requiered parameters to get forecasts (it works in my…
K4timini
  • 711
  • 2
  • 14
  • 34
0
votes
2 answers

Power-Pivot:500 Internal Server Error

I am importing the ssrs report from .automsvc extension and I am facing the below issue as .Can any one help me how can I solve this issue Tablix1: The remote server returned an error: (500) Internal Server Error.
MSA
  • 115
  • 1
  • 8
0
votes
1 answer

PowerPivot - How to create a INNER JOIN between multiple sources

I'm working on a PowerPivot project and I need to create a join between a SQL Server query retrieving a list of products (including prices) and an Excel data sheet containing products and other prices. The objective is to compare the price of my…
K4timini
  • 711
  • 2
  • 14
  • 34
0
votes
1 answer

How can I limit the number of results in PowerView chart

I can't figure this out and maybe its not possible with this tool. Maybe something like Performance Point is better for this (I've never used PP, just from what I read) What I'm looking to is to shop sales by firm in a bar chart but limit the result…
Mark O Keeffe
  • 191
  • 2
  • 15
0
votes
1 answer

Change design of powerView Excel 2013

Can I change the design of the pie chat color to custom color and change the design of the filters in powerView?
Shimon Geld
  • 89
  • 11
0
votes
1 answer

Dynamic Security - Power View Cabable of?

i am currently trying to create some Dashboard Reports using Power View for all Employees. But i can't allow for any Users being able to see the Data of the other. Is Power View capable of Determining which user is logged on and give that to my…
gberisha
  • 291
  • 5
  • 17
0
votes
1 answer

Filter mutliple tables with one Tile

i am currently trying to Filter all of my Tables in a sheet using one Tile for the Employees. I have tried selecting everything, but then The Tile Button gets greyed out. is there anyway of filterin everyithing through 1 ?
gberisha
  • 291
  • 5
  • 17
1 2 3 4 5
6
7