Fix Power Query Glitch for Loaded Tables
When loading Power Query as a table into Excel you can add formula to adjacent columns and they will copy down automatically. However when refreshed the formula does not copy down correctly unless you change Table Properties to Preserve Column Sort / Filter Layout https://www.linkedin.com/...
default use original column name as prefix
Every time I merge 2 queries and expand the new column I have to uncheck "use original column name as prefix". Can we make unchecked the default?
Duplicate Column causes combine binaries to fail
When using PBI Desktop Combine Binaries to import CSV files, if you add a transformation step of DUPLICATE COLUMN it cause the function to fail (this happens if you create the function manually also)
5 Suggestions to improve the new .com layout
screenshots posted here... http://community.powerbi.com/oxcrx34285/board/message?board.id=power-bi-web-app&message.id=16916#M16916
Make the delimiter count dynamic on refresh
When setting data to split by delimiter it fixes the count of delimiters based on the data at that time, this can lead to issues on future refresh https://www.linkedin.com/pulse/take-care-when-splitting-cells-wyn-hopkins
Let us post images with our ideas
It would be really helpful if we could post images here to assist explaining our ideas, especially with regard to layout
Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button
The Query Editor allows you to easily create Year, Month, Month Name etc, but many people need Fiscal Month No and Fiscal year
When right-clicking on the table name in the field list add the option to "show data"
When developing models it would be really useful to be able to jump to the data view for a specific table by right-clicking on the table in the field list and selecting "Data View" from the right click menu
Power Query Renaming a column based on position rather than existing column name
It's currently not possible to rename a column without the M code referencing the existing column name (not without the use of complex function). It would be great if we could easily rename based on Column number as well. E.g. Column2 will be renamed as "Region" regardless of what Column2...
Default measure format to comma and zero decimals
Every time I create a measure I have to format it as “,” and 0 decimals. This appears to be the most common format and it would make sense to make this the default.