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
5
votes
3 answers

Error Creating Power View sheets from SSAS Tabular

I am getting a strange error when creating Excel 2013 Power View sheets off an Analysis Services (SSAS) Tabular instance running on an Azure VM in the cloud. Here is the error: Sorry, something went wrong while loading the model for the item or…
Jondlm
  • 8,764
  • 2
  • 24
  • 30
4
votes
1 answer

DAX Dynamic Total with Power View

I am attempting to graph, via Power View, the sum of all account balances at various points in time, so that I can see how the total is changing. I do not have transaction history (add / subtract), only 'Balance' at a specific point in time for each…
Dave Hughes
  • 41
  • 1
3
votes
2 answers

PowerView in Excel 2010

Can anybody tell me any difference in PowerView in Excel 2010 and PowerView in Excel 2013? I have already tried looking for differences but couldn't find the information i need.
Jessica Mallick
  • 63
  • 1
  • 1
  • 6
3
votes
1 answer

How can I enable Power View in SharePoint 2013?

I use SharePoint 2013 and Performance Point Service for create Business Intelligence report. I need more functionality in report generate. I found that Power View in this scenario can help me but I do not know How I can install and configure Power…
Ardalan Shahgholi
  • 11,967
  • 21
  • 108
  • 144
3
votes
1 answer

Setting Excel power view settings from c# app

I have BI app that extracts data from data source and shows it in excel, i am wondering is it possible to show the data in excel directly as Power View , so is there any code to control the excel power View settings using c#.
user2806836
  • 31
  • 2
3
votes
1 answer

How to display Power View Reports inside asp.net website

We have a powerview report (.rdlx) created in sharepoint and is accessible from sharepoint. My objective is to create a .aspx page and call the powerview report in it. I can do it using iframe but thats not what I want. In iframe, the menu ribbon…
S. Swaroop
  • 411
  • 1
  • 6
  • 17
2
votes
1 answer

MS Excel 2016, Power View, Image URL unable to increase size

GitHub Repository with photos.xlsx file and Photographs (link) Software: MS Excel 2016 with Power View enabled I created Power View report in photos.xlsx that displays photograph and numbers next to it. How do I increase size of…
Rhonda
  • 1,661
  • 5
  • 31
  • 65
2
votes
1 answer

What is the DAX for sum of percentages

I have a table where I have to create percentages by looping on the same table. Here is the sample table My first hurdle is to create the %Weightage, which for a given day, is the percentage of revenue divided by all the revenues for "that"…
user3669763
  • 31
  • 1
  • 1
  • 4
2
votes
1 answer

SSAS Tabular calculated measures missing from Power View fields list

I have defined a calculated measure named "Gross Margin" for my "FactInvoiceLineItem" table. I can see this measure in the Measures dimension (along with several others): These measures work fine in a PivotTable, but they are absent from the field…
3bh
  • 806
  • 1
  • 6
  • 12
2
votes
1 answer

Power View: Dynamic Filters possible?

My Boss wants to Switch to Power View from Reporting Services, but he wants to know if everything you could do in SSRS is available in Power View first. One of the things I noticed immediately is that I couldn't define the filter values for the…
gberisha
  • 291
  • 5
  • 17
2
votes
1 answer

Is it possible to deploy or extract a power view report from Excel to Sharepoint

I created some very nifty Power View reports in excel, however I would like to view the reports from sharepoint without opening excel first (as if the power view was created entirely from sharepoint without Excel). The most valable solution I could…
Yoeri
  • 2,249
  • 18
  • 33
2
votes
3 answers

SSRS 2008 vs SSRS 2012

I've been trying to figure out if it makes sense to use SSRS 2012 with PowerView vs using SSRS 2008. I've following questions: What's better in SSRS 2012 without PowerView(ie without using Sharepoint)? What edition of SharePoint you need to make…
ns12345
  • 3,079
  • 5
  • 41
  • 62
1
vote
0 answers

Understanding Basic Structure for Get-ObjectAcl?

I want to understand the basic structure of Get-ObjectAcl PowerView cmdlet. I want to learn about enumerating permissions on the object, and I come to know with PowerView we can easily do that. All the things I am doing in my local environment to…
Utkarsh Agrawal
  • 65
  • 1
  • 1
  • 8
1
vote
1 answer

Disabling Get-NetLocalGroup

I know that running NetCease tool on a host could disable other hosts from enumerating session on it. I wonder if there is a way to disable other PowerView functions such as “Get-netlocalgroup” (namely, disable the "NetLocalGroupEnum" WIN32 API…
niceGuy
  • 311
  • 3
  • 12
1
vote
2 answers

Aggregate the last value for child categories with DAX

I need to sum the values of stock on hand at a selected date, these values need to roll up into 2 or more categories. The following measure gives me the on hand value at the lowest level item, but when it rolls up to the sub Category or Category…
WViviers
  • 41
  • 5
1
2 3 4 5 6 7