topic Re: Azure Stream backed by SQL in Developer

Azure Stream backed by SQL

jborn — Thu, 22 Apr 2021 20:13:29 GMT

The other day I created a streaming dataset backed by SQL. This used this method https://sqlitybi.com/streaming-data-from-sql-server-to-power-bi-using-powershell/?doing_wp_cron=1617589145.8024311065673828125000

Now I'd like to do the same thing with an Azure Stream backed by SQL. Has anyone done this before?

Re: Azure Stream backed by SQL

v-lionel-msft — Mon, 26 Apr 2021 08:38:40 GMT

Hi @jborn ,

Please refer to the link.

Power BI dashboard integration with Azure Stream Analytics | Microsoft Docs

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Azure Stream backed by SQL

jborn — Mon, 26 Apr 2021 20:16:22 GMT

The telcogenerator.exe is a black box that I'd like a more focused totorial/example for that queries a database at set intervals for any new data based on a watermark (rowversion column in SQL Server) in the database. This new data is then streamed to Power BI.