Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Power Query for Excel January update

21 Jan 2015   #1

64-bit Windows 10 Pro
Power Query for Excel January update

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.
You can download this update from the Power Query download page.
Watch the following video or read the original announcement in the Power BI Blog for details about each feature.

We hope that you enjoy this update and find the new features valuable. Please send us your feedback or suggestions via Smile/Frown in Power Query.

Source: Power Query January updateâ

My System SpecsSystem Spec
21 Jan 2015   #2

Linux CENTOS 7 / various Windows OS'es and servers

Hi there

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.


My System SpecsSystem Spec

 Power Query for Excel January update

Thread Tools

Similar help and support threads
Thread Forum
May 2017 updates for Get & Transform Excel 2016 & Power Query add-in
Source: May 2017 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs
April 2017 updates for Get & Transform in Excel 2016 and Power Query
Source: April 2017 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs
Hi Guys, I havecreated an Excel spreadsheet. I have hyperlinked various cells to other foldersbut I’m getting a warning (See Below) appearing when I click inside the cellwhich has been hyperlinked, the warning says that the folder I am linking to isan “unsafe location do you want to continue...
Microsoft Office
Advisory 979352 Update for Monday January 18
Description of the January 2010 update for Office Word.
Source - Description of the January 2010 update for Office Word
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 23:26.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App