Joe_Edwards1
6 years agoNew Member
Status:
Needs Votes
Add a hash or checksum function to Power Query (M)
In Power Query (M) in both Power BI and Dataflows there is no checksum or hash function. This means that you have to concatenate and compare columns as a large string which is slow and inefficient. The ability to checksum or hash a record or set of columns in a record would complement incremental refresh perfectly, allowing you to implement change detection and derive edit datetimes for a transformed set of data. A choice of hashing functions would also be a helpful addition. A further benefit would be the ability to generate a single deterministic integer key from a composite join, which supports the Power BI single column join principle, and is much needed with incremental refresh because you can't use an index column where you are only reprocessing part of the dataset.
2 Comments
- simon_goemans1New Member
Something like the link below would be great. Not too hard to implement, but would be nice if it came out the box
https://community.powerbi.com/t5/Desktop/Privacy-Hashing-of-keys/m-p/110574
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Support QR codes in the barcode scanner in the Power BI app
I was surprised to find that the barcode scanner inside of a Power BI report in the mobile app only supports scanning barcodes, not QR codes. Our warehouse uses QR codes everywhere, so I cannot use t...Jaap_O_RFH1 hour agoNew MemberNew11Views0likes0CommentsAllow enabling Lakehouse Schemas on an existing Lakehouse
Right now Lakehouse Schemas can only be turned on when you first create a Lakehouse. If you already have one running in production and later decide you need schemas, there is no way to enabled them o...AlessioAndriulo1 hour agoAdvocate INew7Views0likes0CommentsAllow enabling Lakehouse Schemas on an existing Lakehouse, without recreating it
Today, Lakehouse Schemas can only be turned on when a Lakehouse is first created. There is no supported way to enable schema support on a Lakehouse that already exists — the only workaround is creati...AlessioAndriulo1 hour agoAdvocate INew26Views4likes0CommentsWorkspace Folder & Subfolder Inventory View for Power BI Reports and Apps
Problem: Many organisations use Power BI workspace folders and nested subfolders to organise reports by department, business area, project, or function. While this structure helps keep content organ...rijesh1 hour agoFrequent VisitorNew6Views1like0Comments