THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

DataMarket and PowerPivot

Yesterday Microsoft released the Windows Azure Marketplace DataMarket (which everyone will simply call DataMarket, I hope). It was previously called Codename “Dallas”. This is an important step toward the empowerment of self-service BI tools. Microsoft also released two add-ins:

Now, I already tried the tools and I discovered some little issues.

The user interface of the Add-In for Excel is more advanced and complete. You can browse DataMarket data sources without leaving Excel, whereas in PowerPivot you need to open a browser window and you can get data preview directly from the browser. The best way to import data is to select the filters in the browser and the click on the button to load data in PowerPivot (you can also select Tableau software as destination for that data). This approach works very well.

As an alternative, when you open the Table Import Wizard for DataMarket you can directly paste a dataset URL into the Azure Datamarket dataset URL textbox. However, if you use the URL published as the Service root URL in the DataMarket pages, then you have to check that the URL has a slash at the end of the string!

In fact, if you use (for example) this URL (that is the one published on the website):

https://api.datamarket.azure.com/Data.ashx/data.gov/Crimes

It is not going to work. You have to use this one instead:

https://api.datamarket.azure.com/Data.ashx/data.gov/Crimes/

This is the only way you can import more than one tables at once by using PowerPivot. I hope they will fix this issue soon, because even if it is not so hard to workaround, it is important to offer a better user experience to PowerPivot users.

Published Friday, October 29, 2010 10:51 AM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Matt Gurren said:

If I already have powerpivot do I have to re-download from powerpivot.com to receive the new feature or is there a different way to upgrade?

October 29, 2010 6:20 PM
 

Marco Russo (SQLBI) said:

Yes, just download and install it - during the setup it recognizes it is an upgrade and act consequently.

October 29, 2010 6:28 PM
 

Nick said:

Please file a bug on Connect for the URL issue.

October 30, 2010 11:35 PM
 

Marco Russo (SQLBI) said:

I just submitted the bug on Connect here:

https://connect.microsoft.com/SQLServer/feedback/details/618366

Please vote it! :)

October 31, 2010 3:53 AM
 

Stan said:

i have been ignoring azure and powepivot for a while now.

what's happening to good old analysis services - from your perspective?

November 1, 2010 2:20 AM
 

Marco Russo (SQLBI) said:

Next week at the PASS Summit there will be important announcements about MS roadmap in BI. And, of course, there will be news for Analysis Services too.

I can only suggest you to study DAX for the future. Also for Analysis Services... :)

November 1, 2010 2:39 AM

Leave a Comment

(required) 
(required) 
Submit

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement