Date formatting is broken in PowerBI Desktop Aug update version 2.38.4491.82 64bit
Date format as shown in PBI Desktop 3, 14, 2001 (M/d/yyyy) 3, 14, 01 (M/d/yy) 03, 14, 01 (MM/dd/yy) 03, 14, 2001 (MM/dd/yyyy) 01, 03, 14 (yy/MM/dd)
Ability to set different table icon colors for visual identification of table types
Currently there is no visual cues to differentiate different types of tables in PBI Desktop. My practice is to prefix each table with "F" for Fact table , "D" for Dimension table and "M" for Measures" table. With color coding, it will help data model developer to quickly visually identify what ta...
Decouple "Enable Load" from "Refresh Preview"
My idea is to separate "Enable Load" from "Refresh Preview" so that toggling "Enable Load" option will not trigger "Refresh Preview". This will eliminate unnecessary data movement during debugging existing Power Query that need to toggle "Enable Load" on and off.
power query date diff function
Add date diff function in power query similar to DAX version.
hash
Implement encryption function in Power Query SHA, MD5, etc. They are useful for speeding up delta data detection and for data merging.