Connect to offline/external PowerPivot model
I'd like the ability to use the model in an existing excel powerpivot workbook (not uploaded to powerbi) as a data source for PBIDesigner or even directly in the powerbi dashboard. Ideally it would work similar to the connection to an on-premise tabular model. I believe tableau offer functionalit...
Add a PowerBi dataset destination task to SSIS
Supply a data flow destination connector for SSIS that'll allow us to push data into PowerBI via the api calls (with options to overwrite/merge/create datasets/tables if they don't already exist) Myself and most BI devs/consultants I know usually aren't the best .net coders, so having a pre-bu...
Fix Compatibility Issues with Power Query (tabular metadata change causes source query to go into read-only mode)
Power Query is the method being pushed as the load mechanism for models on PowerBI. And a good thing too, PQ is probably one of the best things MS has come out in this space for a while. But it doesn't work well with Power Pivot. Currently the development is one way. Any changes in power pivot...
Add Unique and Foreign Key Constraint Support to Clustered Columnstore Indexes
Posted on connect but just putting here as well: https://connect.microsoft.com/SQLServer/feedback/details/1031466/constraints-on-clustered-column-store-indexes Currently clustered columnstore indexed tables only support not null constraints. Unique and foreign key (even unenforced - just for m...
Charting functions (eg rolling sum waterfall/line) across multiple measures
Allow a chart and function (eg rolling sum) across multiple measures on the same axis so that a waterfall chart can be created from different measures, not just the same measure across different attibutes of one dimension. Eg Sale Price-Freight-COGS=Profit
SSMS 17 Bug: Can't copy from dialog popups: Unsaved documents cannot be cut or copied to the clipboard from the Miscellaneous Files project
There's a bug in the current 'separate installer' version of SSMS (2016 onwards) It doesn't allow copy pasting from some dialog popups. Noticed it in the find & search/replace dialog. I use this feature extensively to refactor code/deploy from template files Never seen any other windows ...