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
- 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
extend storage capacity of varchar(8000) to varchar(max) for warehouse
The maximum string length of 8000 is often considered too short to store longer descriptive data or embed a JSON value within a text field in a database. Dividing the data into smaller chunks and st...c_mettler16 hours agoNew MemberCompleted3.3KViews61likes13CommentsAdjust column width in SQL Analytics Endpoint user interface
I can't see the column names and cell values in some of the columns in my tables in SQL Analytics Endpoint because the column width is too narrow. Also, the tooltip also doesn't show the entire...frithjof_v16 hours agoCommunity ChampionCompleted4.2KViews75likes8CommentsIn TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >"
Using in the Power Bi's Service Cloud. In TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >" and selects & clicks the drillthrough page. In TableEX vis...LR318 hours agoRegular VisitorNew4Views0likes0CommentsAllow Power BI subscription sender identity to be configured
The new Power BI subscription delivery platform changed existing subscriptions so that notification emails now show the subscription owner as the sender instead of mailto:[email protected]...bbussey20 hours agoRegular VisitorNew21Views4likes2CommentsSupport Workspaces folder pairing across Fabric Deployment Pipeline stages
Fabric Deployment Pipelines should support deploying items organized in workspace folders when equivalent folder structures exist across stages. Currently, deployments can be blocked when items are ...majofv21 hours agoNew MemberNew6Views0likes0Comments