THE SQL Server Blog Spot on the Web

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

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

The ultimate Calendar table for #powerpivot (and #ssas, why not)

Boyan Penev announced the availability of DateStream project on CodePlex: it is a data feed that can be consumed by PowerPivot but also to generate a calendar table for any type of usage. Yes, Analysis Services has a wizard, but when you are in a hurry why not simply consume a ready to go data source?

In fact, this data feed is published for free on Azure DataMarket:

I would like to get feedback – in my opinion performance are not very good but hearing words from other users would be nice.

Thanks to Boyan for his effort!

Published Monday, October 10, 2011 3:09 PM by Marco Russo (SQLBI)



Tom said:


I got the next error:

"BasicCalendarEnglish: The remote server returned an error: (403) Forbidden."

October 10, 2011 2:16 PM

Marco Russo (SQLBI) said:

How exactly you've got the error? You were doing what?



October 10, 2011 2:20 PM

Lee Hawthorn said:

This is a nice idea but I prefer to populate my date table from a SQL view.  The server being on my LAN makes it super quick.

This may be a good for people with no SQL server.


October 11, 2011 2:56 AM

Bhavik Merchant said:

Hi Marco,

Same problem here.

1. enter the feed URL and account key. Test Connection is Successful.

2. Go to next screen, it will list the 3 calendar tables available

3. After i select tables, if i try to "Preview and Filter" or "Finish" the wizard it will give 403 error. At this stage you cannot continue.

it would appreacite it if you could also communicate on bhavik.merchant(at) - your blog doesnt seem to have a comment email subscritpion. Thanks!

October 19, 2011 7:09 PM

Marco Russo (SQLBI) said:

Have you signed up the feed? You should open the URL on your browser and then sign up the data feed before importing it in PowerPivot.


October 19, 2011 8:03 PM

Bhavik Merchant said:

thanks Marco, i forgot to do this :) working now. I agree that it is very slow, but that is a small price to pay i guess!

p.s. comment registration for email is giving this error:

"The administrator has disabled new account creation. Please check back later - or email the administrator - to see if it is possible to register."

October 19, 2011 11:20 PM
New Comments to this post are disabled

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



Privacy Statement