Quick post today, as I am travelling again.  PowerPivot’s version of Tyler Durden Smile

If you installed Data Explorer a couple weeks back, go look at your Data Explorer ribbon tab today:

image

This “Update” Button “Lit Up” Last Week – Click It Smile
(I already did, so mine is now disabled again)

That will launch you into a surprisingly painless update.  Pretty nifty.

New Features

They added support for a few new data source types:

  1. Azure HDInsight – the MS cloud version of Hadoop
  2. Teradata
  3. PostgreSQL

They also improved the query editing experience.

Full details here:  http://blogs.msdn.com/b/dataexplorer/archive/2013/03/12/a-new-build-of-data-explorer-and-an-auto-update-feature.aspx

Download it From Scratch

If you haven’t downloaded data explorer yet, you can get it here:

http://office.microsoft.com/en-us/excel/download-data-explorer-for-excel-FX104018616.aspx

What the Heck is Data Explorer?

Read this quick post from two weeks ago

Rob Collie

One of the founding engineers behind Power Pivot during his 14-year career at Microsoft, and creator of the world’s first cloud Power Pivot service, Rob is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology.

This Post Has 3 Comments

  1. Well, this time I’m trying to connect to a SQL 2000 server and I’m getting the error DataSource.Error: Microsoft SQL: Invalid object name ‘sys.databases’.

    So that’s a change, at least 🙂

  2. Great post! If you’d like to try the tool out with an extended selection of datasets, I’d recommend checking out our site: http://www.quandl.com

    We have over 4 million freely accessible datasets that could be pretty fun to pull into Data Explorer.

    Feel free to give me a shout if you have any questions.

Leave a Comment or Question