Ability to connect Excel to Power BI Data Model and create Pivot/Charts
Just the way we are able to upload a Power Pivot Model to SharePoint and then connect an Excel workbook to the model hosted on SharePoint (See http://www.powerpivotpro.com/wp-content/uploads/2015/07/SharePoint_PowerPivot_ToExcel.png) ... ...In a similar manner we should be able to connect Excel t...
Diagram View in Power Query showing interconnections across various queries
See image http://www.powerpivotpro.com/wp-content/uploads/2015/08/PQ_DiagramFlow.png - that is a Power Query flow for an actual client project that I built using Power Point and maintain manually as the Queries change. Each box represents a distinct query in Power Query. It would be SUPER useful ...
Q&A should not consider hidden columns or ability to turn off columns for Q&A
Q&A seems to be considering hidden columns as well. (screenshot at the end) It would be highly preferred, if either > Hidden columns are not considered in Q&A > Authors given ability to exclude hidden columns (or perhaps even other columns) from Q&A. This can possibly be exposed via the Syno...
Column Profiling Based on All Rows (Data Profiling)
Loving the new Data Profiling feature. I totally get the logic of only using the first 1000 rows of data to show the Column Profile. But similar to how in the "Filter" Dialog it gives me the option to "Load More". Would like the option to Load the Complete Profile of the Column based on all Data ...