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
Brink

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

Quote:
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
jimbo45

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.

Thanks

Cheers
jimbo
My System SpecsSystem Spec
Reply

 Power Query for Excel January update




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
W7 keeps deleting my excel ss desktop icon whenever I update it??
Whenever I update my Excel speadsheet after first opening it by clicking the desktop icon. It then deletes the desktop icon when I save the sheet. It only does it with this particular icon. If I try copying the ss from another backup location back onto the desktop it says 'this is a duplicate...
Microsoft Office
The Mysterious power of Ms Excel --enjoy !!!
Hi there Office and in particular Ms EXCEL users Enjoy BBC News - The mysterious powers of Microsoft Excel Cheers jimbo
Microsoft Office
Excel grabbing focus on web update
I have an excel spread sheet pulling web queries on stock market data every few minutes. Every time it updates it jumps to the foreground and won't let me continue with any other app until the update has finnished. This never happened in 2007 so how can I turn this off? I am using windows 7 64...
Microsoft Office
Laptop power supply query
Yesterday my laptop's power supply blew :cry: I sent it in for repairs and was told that it would take 10-30 working days!! Yikes! Big question: can I use my wife's power supply in the meantime? My one had an output of 19V 4,72A 90W while hers has an output of 18,5V 3,5A 65W. Is this do-able?
Hardware & Devices
Advisory 979352 Update for Monday January 18
More...
News
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 03:42.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App