The latest set of updates finally sees the General Availability of the new Format Pane, plus error bars and information protection updates, table navigation improvements, Connect to datamarts and Power BI Data Storytelling features. But, as always (and of course!), there’s more.
Power Query Refresh is now Generally Available in Excel for the web for queries sourcing data from the current workbook and anonymous OData feeds. Slowly but surely, the full Power Query capabilities are coming to the online variant of Excel!
When Power Query was first released in Excel for Mac, there was hope that it wouldn’t take long for the features to mirror their Window counterparts. It’s taking time, but the capabilities are improving.
Microsoft has recently upped its game with blocking macros. They argue that macro-based malware is on the rise and thus they are blocking macros from more and more external / third party locations. Protected mode seems insufficient.