Forum Discussion

Helper V

9 years ago

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

Need Help

otravers

Community Champion

9 years ago

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)