Excel Pivot Tables in PowerBI with on-prem data
The latest update of Excel and PowerBI on the Insight Summit is good. But what we also need is the ability to work with an Excel Pivot Table, Pivot Chart where the data resides on premises, as opposed to data being exported or uploaded to the service.
Tile Explanation
Many a times a small explanation has to be held for each report / dashboard tile to the user a brief explanation of the chart. It would be good to have a property for each chart something similar to an Excel Comment. This should be visible on clicking an icon in the toolbar which comes above each...
Filter area : See all, See Filtered, See Unfiltered
In the filters area, i should be able to see All Values, Only Filtered Values, or only Non-Filtered Values. This option should be for each table, and also for the entire filter pane. This (esp see filtered values) will help me see all the filters which i have applied, and then i can selectively r...
PowerBI Report Tile Popout
If I have put a watermark on the report and set the transparency to low, and if i pop out a tile, the transparency carries over to the popped out page. Unfortunately the popped out page shows the original dashboard in the background also, making the image unusable.
PowerBI Format Settings
There should be a method by which I can set up all kinds of settings e.g. Font size of X-Axis, Font Colours which I would normally use and save this as a design template. This will save a considerable amount of time.
Custom Visual Categorisation
Please categorise custom visuals into the ones which are still "experimental" or under development, and the ones which are ready to be used in production environment.
Refresh Message - Moving Dotted Circle
On slow connections to the internet, when a user selects a filter it takes time to refresh the various tiles in a report. But the icon of refresh ie the dotted moving circle which comes on the upper left hand side, is not very noticeable. Plus this is for each tile separately. one does not come ...
Connect a Excel Pivot Table Report via PowerBI to On Premise
While Analyse in Excel is a good idea, essentially it would mean formatting the Pivot Table each time such a functionality is called. What we really need is to upload a Pivot Table to PowerBI.com as a report which can be called from the PowerBI interface, and which then connects to On-premise usi...
Page and Report Filters
Both the Page and Report filters should be considered in the functionality of "Edit Interactions", just like a slicer is. For example lets say that I have a trend chart showing me all the months of the year. Other charts are for say Product Bar Chart, Customer grid etc.. Now if I want to see Prod...
Powerbi and PowerPoint
While now we can link the PowerBI report / dashboard to a PowerPoint slide deck, I cannot link individual report pages to the slide deck. I should be able to link a page and when I go to powerpoint that specific page should open.