Save PowerQuery data to a data store - Azure,Mongo or Other RRS feed

  • Question

  • If everyday my PowerQuery updates with new data and I everyday lose the data from the api call I have, what is the best way to save the data from my queries to an sql table or other suitable storage mechanism.

    I mean the data is json when it comes in should I/ can I pass it from PowerQuery directly to mongodb or is there a good Azure storage service to keep my data so then I can perform historical queries across time periods?

    Taking my C# further

    Thursday, April 20, 2017 6:44 AM