Azure Datestream

bhmiller89 · ‎02-01-2017

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

otravers · ‎02-13-2017

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)

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

jhodge · ‎04-04-2017

What is everyone doing now that DateStream via Azure Marketplace is no longer available?

jhodge · ‎04-04-2017

I am using this method

https://www.mattmasson.com/2014/02/creating-a-date-dimension-with-a-power-query-script/

parry2k · ‎02-01-2017

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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.