Chris Webb shows how to use Streaming Datasets functionality in Power BI:
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)
Sends the data to the streaming dataset using Web.Contents() to make a POST request. See this post on how to make POST requests using Web.Contents() and this post on the technique I’m using to handle HTTP errors manually.
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.