Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Add Table.AddKey Functionality to UI to Optimise Queries

It seems as though there is a performance benefit to query runtime when manually adding keys which currently has to be done in M (see: https://blog.crossjoin.co.uk/2018/03/16/improving-the-performance-of-aggregation-after-a-merge-in-power-bi-and-excel-power-query-gettransform/) This may be particularly true when creating a join on a csv, for example, where a foreign key may vastly improve performance. Please allow us to do this in the UI rather than needing to modify the M behind a table
Status: Needs Votes
Comments
fbcideas_migusr
New Member
Status changed to: Needs Votes