Option to cache datasets in memory, especially in Power Query mode
The example I have is I'm working with a ~300MB CSV file. Every time I make any transforms on the file in Power Query, it goes and fully retrieves the CSV, performs the transform, then dumps it out again. Needless to say this gets really tedious in development mode. It would be nice to be a...
SAP Navigational Attributes
In SAP BW, there is a concept called a navigational attribute. It is essentially an attribute referenced by (i.e. “navigated to”) a dimension but whose values are stored outside of the dimension and retrieved at runtime. SAP native tools handle these attributes as dimensional attributes of the...
Remember "DirectQuery" setting when retrying data navigation
A tiny but real issue: if you choose DirectQuery and then for whatever reason your connection fails, PowerBI offers you the option to "Retry" ... but then it resets the Import/DirectQuery setting back to Import. And if you miss this tiny detail you can't retroactively change the data source sett...
Add Column to Split Column Query Editor UI
The "Split Column by Delimiter" UI doesn't include the column on which the split is performed, so if a user performs the split on the wrong column they have to either delete the step or open the Advanced Query Editor and edit the M script directly. Please add the Column being split on to the Spl...