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...

Read more...
2 Comments

Read more...
2 Comments

STATUS DETAILS
Needs Votes

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.

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

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 ...

Read more...
1 Comments

Read more...
1 Comments

STATUS DETAILS
Needs Votes

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.

Read more...
1 Comments

Read more...
1 Comments

STATUS DETAILS
Needs Votes