I have been extensively using Power Query at work to automate pulling data from 20 different excel files, access data base and other sources. What I really like about Power Query is I can reorder the...
Get the excel team to implement it because currently the desktop app is hideous and barely usable. Just get some UX people to actually spend time on it. I have to google everything like how to reorder columns, how to do such simple things that are straight forward in any database or spreadsheet. Building a web based UI from scratch would be quicker.
