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
Productivity Boost: Excel-like Tab Management and Navigation for Power BI Desktop
The Problem: Currently, navigating and organizing report pages in Power BI Desktop becomes inefficient and frustrating when a report has many tabs. The small navigation arrows and the lack of standar...michel_onesti1 hour agoNew MemberNew153Views6likes1CommentOption to Stop Fabric Planning Billing Session After Plan Item Deletion
Currently, a Fabric Planning session remains active for 30 days once triggered. If a user creates a Plan item only for testing and deletes it the next day, the billing session still continues and c...v-dugumarrir11 hour agoMicrosoft EmployeeNew22Views9likes0CommentsAllow selecting specific Fabric items to pull when using Update from Git
I’d like to suggest adding selective item deployment to Microsoft Fabric’s Update from Git experience. Today, when a Fabric workspace is connected to Git, Update from Git is primarily focused on syn...dprenc_elixirr4 hours agoAdvocate INew11Views0likes0CommentsDependency-aware Update from Git operations
I’d like to suggest improving Update from Git in Microsoft Fabric so that it becomes more dependency-aware during deployments. Git deployment can become fragile when multiple Fabric items depend on ...dprenc_elixirr4 hours agoAdvocate INew7Views0likes0CommentsAPI for Get Refresh Schedule of Dataflows
Currently, there is no way to get the actual refresh schedules of dataflows through the API. It is very important to see the coordination of dataflow and dataset refresh schedules. This seems like a...Andrew_Foulk25 hours agoNew MemberNew594Views28likes5Comments