Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
bhmiller89
Helper V
Helper V

Azure Datestream

‎02-01-2017 02:50 PM

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

 
Labels:
Message 1 of 5
3,074 Views
0
4 REPLIES 4
otravers
Community Champion
Community Champion

‎02-13-2017 07:40 AM

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
Message 3 of 5
3,035 Views
0
jhodge
New Member
In response to otravers

‎04-04-2017 02:43 AM

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

Message 4 of 5
2,976 Views
0
jhodge
New Member
In response to jhodge

‎04-04-2017 03:34 AM

I am using this method

 

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

 

Message 5 of 5
2,972 Views
0
parry2k
Super User
Super User

‎02-01-2017 06:05 PM
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.

Message 2 of 5
3,062 Views
0

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All
Top Solution Authors
View All