In this blog post we want to give you an overview of the new Power Query features included as part of the Power BI for Office 365 offering. Along with several other self-service BI capabilities in Power BI, we are enhancing the Power Query experiences and feature set in Excel. You can download the latest Power Query preview add-in update and start using it today, and also sign up to use the Power BI service to enjoy a full set of self-service BI and collaboration features.
Here is a summary of the new features that you will get in this update, compared to the Power Query GA release from a few months ago:
In addition to new features, Power Query Preview is now available in 17 different languages: English, Spanish, French, German, Chinese (Simplified), Chinese (Traditional), Danish, Dutch, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Russian, Swedish and Turkish. If your preferred language is not in this list yet, don’t worry… We’ll be adding more languages soon!
We hope that you are as excited as we are about these new features and that you continue enjoying Power Query and sending us feedback.
Finnish, please. ;)
Thanks Heidi. You won't have to wait too long for that to happen... Stay tuned : )
Will any of these updates also be available in the stand alone production version of Power Query?
No, these updates will not be available in the standalone version. You can think of it as Standalone being the last version of Power Query that is recommended for production scenarios, and this Preview being an early look at what the next version could include. We want to continue releasing previews of new capabilities early and often, to leverage customer feedback in order to shape a better product. (Caveat: Features in final version might vary compared to Preview versions)
where on this page is the update link? I've clicked on any number of links and get sent to fresh install pages, which are useless.
This is the download link: www.microsoft.com/.../details.aspx
You'll need to run the setup as if it was the first time that you install. You don't need to uninstall first, it will just do it for you. The only thing you need to make sure is that you don't have any Excel instance running when you try to run PQ setup.
Hope this helps.
Please provide a MUI package like PowerPivot has got: only one installer and automatical detection which Office language is active => this would reduce packaging and managing effort in Enterprise environments
Is there any entry point for support ?
I like Power Query, but two suggestions.
1) Could be possible to add PowerPivot DataModel and Analysis Services as a source for Power Query
2) Could be possible to add a fonctionnality to load data in a SQL Table
That could help for accumulating data beyond the limit of Excel and autorize new possibilities for ETLing Data.
Thanks. This is the information i was looking for. Thanks.:)
I can't use the latest version of PowerQuery in Excel 2013 to access Windows Azure Table Storage as the option is missing in the 'From other Sources' option as described in step 1 on office.microsoft.com/.../connect-to-windows-azure-blob-storage-HA104113447.aspx "In the POWER QUERY ribbon tab, click From Other Sources > From Windows Azure Blob Storage.".
Does this mean it's not available on this platform, or I need to install something else to make the option appear?
Comments in this blog are open and monitored for each post for a period of one week after the posting date. If you have a specific question about a blog post that is older than one week, please submit your question via our Twitter handle @MSPowerBI