Store real-time data from web in a table to snapshot the historical data and produce trends

[iDataDrew]

Basically, I want to capture/store/snapshot live data from the web using DAX.  Is this a possibility?  I saw another post (https://goo.gl/YXEGTb) which seems to be related, but I couldn't tell if it's quite the same thing I'm looking for here.

An example of the kind of data I'm looking to snapshot is here: http://www.pjm.com/pub/account/lmpgen/lmppost.html 

the Aggregate Locational Marginal Prices (LMP) table updates every 5 minutes.  Right now I can only show its current state.  But if I could capture the data every time it refreshes and store it into a separate table then I could show things like trends.

Thanks for your help.

[v-ljerr-msft]

Hi @iDataDrew,

As Power BI is a tool for analysing data, not for storing data like a database, I would suggest you to store the Web data(every 5 minutes) into a database or some files(CSV, Excel) as smoupre mentioned above first, then use Power BI to import the data from them and produce trends in this scenario.

Regards

[Greg_Deckler]

I don't think you could get there using DAX but you could theoretically write your Power Query in such a way that it created a new table each time that it runs so that you do not lose the data. I would think that once you start going down that route it would make more sense to store it in a database. You could use an R-based query to achieve that.