This query does the following:
Reads the data from the Sales table in the workbook
Converts the data to JSON (for some background on how it does this, see here)
Returns a table containing a message saying whether the data was updated successfully or not, and the time of execution like so:
There are some limitations on what’s available now, but getting streaming data out to Power BI can make a near-real-time dashboard possible.