Azure Stream backed by SQL

[jborn]

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=1617...

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

[jborn]

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.

[v-lionel-msft]

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.