akpmaya.blogg.se

Power Query is a powerful and timesaving set of tools that help you get and shape data quickly and easily.

I’m excited to share with you that you now can clean and shape your data from local files, SharePoint, SQL, and tables and ranges with Power Query Editor in Excel for Mac! Shape data with Power Query Editor Recently, though, I became aware of a JavaScript library developed by the Excel Power Query team called “Connected Workbooks” that makes it extremely easy to do this.Hey Insiders! My name is Inbar Privman, and I’m a Product Manager on the Excel team. It’s always been possible to build yourself but technically difficult. So wouldn’t be good if you could export to Excel and instead of getting a static copy of the data, you could get a table connected to a Power Query query which in turn connected back to the original data source, so it could be refreshed whenever the user wanted? After all, pretty much everyone nowadays has a version of Excel with Power Query in it (even, with some limitations, Mac users). Of course the reason we joke about it is that we know it’s a Bad Thing and the starting point for all kinds of manual, error-prone and time-consuming business processes – but even though we know there are much better ways of achieving whatever it is the user wants to do, they still want to export to Excel. In fact, I’d say export to Excel is one of the most important features of any enterprise application of any type. There’s an old joke about “Export to Excel” being the most important feature of any BI tool.