Power Query for Excel enhances the Business Intelligence (BI) experience by simplifying data discovery, access and collaboration. The Power Query team continually works to improve the Power Query experience and their January update includes a new connector—or many new connectors, in this case—and a host of usability improvements.
What’s new in this update?
The following features have been added or improved in this update:
ODBC Connector—New connector which enables importing data from generic ODBC data sources in Power Query.
“From Azure” ribbon dropdown menu—New ribbon dropdown menu to group all Microsoft Azure data sources in Power Query. Makes it easier to browse and find items in the “Get External Data” ribbon group.
Workbook Settings dialog—New dialog to expose workbook-specific settings such as Locale, Fast Combine and Relationship Detection.
Option to enable or disable relationship detection—Control whether Power Query should attempt to create relationships between tables when loading queries to the Data Model.
Column and Row counts in Query Editor Preview—Quickly get a sense for the shape and size of your data by looking at Column and Row counts in the Query Editor Preview.
Confirmation dialog to delete a query when deleting a worksheet—Decide whether to remove queries or to disable “load to worksheet” when deleting a worksheet where one or more PQ queries are loaded.
Just a suggestion - this also works on EXCEL 2010 for those who haven't upgraded(?? !! think it's actually worse than 2010) to Office / EXCEL 2013 / Office 365.
Nice addin.
The OBDC part is particularly interesting (for me) and I think I'll have a lot of interesting tests with BI queries.
Thanks
Cheers
jimbo
My Computer
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Custom built, several laptops HP/ASUS
OS
Linux CENTOS 7 / various Windows OS'es and servers
