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.
3 Comments
- TurkaKris
Advocate II
It would be very helpful.
- fbcideas_migusrNew MemberStatus added:Needs Votes
- 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
Recent ideas
Return .png Attachments to Subscriptions
With the latest update to Power BI subscriptions, the separate .png report snapshot attachment has been removed. From Microsoft’s troubleshooting documentation, this appears to be an intentional chan...KDC_Group_PBI12 minutes agoNew MemberNew74Views9likes2CommentsPlease reverse the subscription email sender
The new update around the subscriptions on the service platform, where the report owner's email ID reflects as the subscription sender rather than the old "no-reply" or a generic Microsoft email addr...rahulchawla20815 minutes agoNew MemberNew3Views0likes0CommentsSubscription email only includes partial data capture
I have subscribed to the 'Power App' subscription, but the automated email only includes a screenshot of the first page of data, without scrolling down to include all of the data in the report. With ...VMS15 minutes agoNew MemberNew3Views0likes0CommentsAllow Custom Sender Identity for Power BI Email Subscriptions
Currently, Power BI email subscriptions do not provide an option to configure or customize the sender identity. For organizations that have specific communication, branding, or email-management requ...Jashwanth_K27 minutes agoMicrosoft EmployeeNew23Views9likes0CommentsGive admins control over the sender of Power BI subscription emails
Power BI's updated subscription email delivery method sends subscription emails from the subscription owner's Exchange Online mailbox. Organizations need the ability to choose a service/no-reply send...aggiemusicag1 hour agoAdvocate INew19Views3likes2Comments