Allow us to set the data type in the Add Custom Column PowerQuery dialog
It would be nice if we could set the data type in the Add Custom Column dialog box for the function we are writing insetead of having to do it manually in the formula bar, or adding an extra step to do it in the Applied Steps. For example: Table.AddColumn(#"Added Credits", "CalcEndBalance", each...
PBIX files should be searched and indexed by Teams, Delve, etc.
There is no way currently to search for a PBIX file by the file contents like you can with Excel, Word, etc. Delve and Teams should both be able to search for the contents of a PBIX file and index them.
Support Change Data Type in SQL Query Folding
If at all possible (not a SQL statement person) it would be nice if you could change the data type and have PQ fold that into the SQL statement. There are a lot of cases where data is stored in other formats. For example, we have a General Ledger table where the date is stored as MM/DD/YYYY, but ...
Add a SUM total in DATA view when filtering data
Love the ability to filter and sort data now in the DATA view grid. It gives us things like Distinct Count, Count, etc. Add "SUM" when the data is numerical.