alex_holloway
7 years agoNew Member
Status:
Needs Votes
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
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
OneLake Catalog full-text and content search
Why is it not possible to search OneLake by item description or even content? So I was thinking about how a user can find a table if they don't know in which lakehouse it is located? Why can't you se...TePe7 hours agoHelper IVPlanned1.1KViews21likes5Comments