Power Query for Excel enhances the Business Intelligence (BI) experience by simplifying data discovery, access and collaboration. The Jan 2015 update for Power Query includes a new connector—or many new connectors, in this case—and a host of usability improvements.
- 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.
Read more about it here.