Forum Discussion
Azure Datestream
I've been using Azure Datestream but need to download the data to an Excel file and use it as a data source in Power BI desktop.
I feel really dumb and once I have the data model in Power Query I can't seem to figure out how to make it work. Have I not actually downloaded the data set? I open Power Query, connect to Azure Marketplace, and load the Datestream calendar data. However, I don't know how to download a forever copy of it that will remain once Azure Marketplace disappears next month
https://datamarket.azure.com/dataset/1542c52d-d466-4094-a801-9ef8fd7c6485
4 Replies
- Drop all the fields on a table visual and choose export, it will give you CSV file. I believe that will get you offline copy.
You can do this either from Power Pivot (but I couldn't figure out where to input a filtered URL so you'll get 73K columns per calendar), or via Power Query to filter to the years you want, in case you don't want to go all the way back to 1900.
Make sure to be Subscribed in the following page if you want to use PQ:
https://datamarket.azure.com/browse/data?query=datestream
For further details see:
- http://www.powerpivotpro.com/2011/11/the-ultimate-date-table/ (comments)
- http://www.powerpivotpro.com/2014/02/the-ultimate-date-tablerevisited/ (includes Power Query method)
What is everyone doing now that DateStream via Azure Marketplace is no longer available?
