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.