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
About "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf5 hours agoFrequent VisitorNew48Views3likes2CommentsEventstream MQTT broker source: V3.1.1 support
The Eventstream MQTT broker source supports connections with public MQTT brokers that offer MQTT V5 support. Please offer support for V3.1.1 too, because this is still a valid and widely used ver...svelde6 hours agoSuper UserCompleted1.4KViews6likes4CommentsGet data from Apache Kafka topics via private networking
Current prerequisites limit to public Kafka instances which is not feasible for most enterprise customers. When will this limitation be lifted so that it can be used in private network setups, for ...Jugi6 hours agoMicrosoft EmployeePlanned3.5KViews2likes3CommentsSet default x axis scrolling position
Enable selection of the default scroll position for the x-axis on a chart. For example, on a line chart with dates as the x-axis, when not all of the data can display in the view at once, the scroll...Lisa_Krieg14 hours agoNew MemberNeeds Votes7.8KViews1154likes104Comments