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
1
vote
2 answers

Filter dynamic in power bi

Is it possible to do a dynamic filter in power Bi? I want to show TOP 20 or TOP 10 or TOP 5 in columns chart. Now I have a filter with less 20 , but I need to mark in slice and show other data. Thank in advance.
Moisés
  • 105
  • 1
  • 8
1
vote
1 answer

Date Filtering Malfunction in Powerview

I am building a reporting solution using Powerview on Sharepoint Server 2013 with ssas multidimensional data source. On the powerview reports I have encountered a strange problem. When I filter using a date attribute with multiple values only the…
1
vote
1 answer

PowerView display on SharePoint 2013 without excel services

I've seen people displaying PowerView reports right on the browser (on SharePoint 2013 pages). So it’s more like a within-screen pop-up (like an element that launches within the page). At the moment, when I create powerView excel sheets, they are…
LearnByReading
  • 1,813
  • 4
  • 21
  • 43
1
vote
0 answers

Conditional Drill Down Powerview

Not sure if this is doable but I just wonder say if my data set got this structure Department, Team, Service, Area and I got a measure lets call it #count that count all rows in this table. When create a powerview chart I want to be able to drill…
PeddiePooh
  • 403
  • 8
  • 17
1
vote
1 answer

How to link table row content to source in Power View

I am currently able to use Power View to view, filter, and highlight my data. However I haven't figured out a way to link my table rows to the data source (i.e. tables in other tabs of the Excel spreadsheet). so that if I double-click on a row,…
1
vote
2 answers

How to create nested tiles in Power View

I am currently able to use the tile feature in Power View to view data much more quickly. However I haven't figured out a way to have nested tiles to further drill down into the relevant data. For example, I want a tile strip at the top of my view…
1
vote
1 answer

Display Image in Power View and Power BI

I need to create a report in power view where I need to display images in tile. I have found one solution to do so, to store the images as a binary data in data model table using the following…
BIDeveloper
  • 767
  • 3
  • 14
  • 28
1
vote
1 answer

Can I integrate PowerView reports in SharePoint without SSRS?

I am new to Microsoft BI and I am wondering if you need SSRS installed in order to deploy a PowerView report to SharePoint. My datasources will be Excel files. I know my company has a SharePoint (don't know yet which version). I don't think SSRS is…
user3248190
  • 101
  • 1
  • 10
1
vote
1 answer

Connecting Multidimensional Cube to PowerView

i am new to SSAS . we can connect tabular model in SSAS to powerview . Can we connect Multidimensional Cube(Datatools) also to Powerview without sharepoint Thanks
1
vote
1 answer

How to open SharePoint Power View Report in Excel 2013

Is it possible to open Power View report in Excel which is originally created in SharePoint 2013. I need to open Power View report in Excel.
Jay Doshi
  • 330
  • 2
  • 5
  • 19
1
vote
2 answers

many to many powerpivot relationship

I have 2 data sets which i would like to create relationships for (there is a third i would like to join but the first 2 are priority). They all have a common link that is design_ID. I did have a picture showing what i have tried. but i do not…
Dan171
  • 55
  • 7
1
vote
2 answers

PowerView spreadsheet throws error when displayed Sharepoint

I'm trying to access a PowerView spreadsheet in Sharepoint 2013 and I get the error below: An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have…
Rajesh
  • 449
  • 2
  • 9
  • 22
1
vote
1 answer

Adding text/comments to Powerview

Does anybody know how to display some text or comments on a PowerView report for example to explain why a graph is what it is ? I do not want to export to PowerPoint and add a shape manually, I would like the text to display within the PowerView…
user1238760
  • 61
  • 2
  • 6
1
vote
0 answers

How to have dynamic interval in DAX/Powerpivot?

Dynamic Band in RDBMS Our challenge is to reproduce the below example (RDBMS) but leveraging Microsoft SSAS Tabular Model. We have value in a column and we need to group them, so literally we have Student with Marks (any value within a certain…
Sarah
  • 133
  • 1
  • 2
  • 7
1
vote
1 answer

Is it possible to order the filters on the filter pane of Power View?

I have noticed that the filters added to the filter pane in Power View Reports are automatically ordered by field name, is there a way to rearrange them without changing the field names? In my case I have diverse date related fields that I want to…
EndyMX
  • 11
  • 3