Allow to select custom data range on Excel sheet on import
When importing data from non-formatted Excel worksheets (not from tables or defined names) Power Query uses an UsedRange property of worksheet (as described there https://social.technet.microsoft.com/Forums/en-US/9d38f271-2cc6-4170-9a48-1e4f45f6f125/missed-column-from-xlsx-worksheet-on-import?for...
Allow equal key column names in Table.Join
In Table.Join function we can use same key column names for JoinKind.Inner option, but need to use different column names for other join types, like Left Outer, Right Outer etc. This limitation demand to add excessive steps for renaming duplicate columns before join and removing them after join. ...
Manage Excel Table Totals Row import
is there a possibility to NOT load totals rows from Excel table? I'm ususally do not use totals in tables so wasn't aware, but now met an unpleasant situation when unfiltered totals row causes problems. I understand that we can filter it out after loading (but sometimes its existence could be r...