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...
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)