Real-Time streaming dashboard with sql server data

SUVARCHALA DEVI 1 Reputation point
2022-07-07T10:50:49.34+00:00

Can I send my SQL Server Data to Power BI for Real-Time Streaming using Stream Analytics Job?

Azure SQL Database
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
324 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,706 Reputation points MVP
    2022-07-07T12:12:13.303+00:00

    Sure you can. Azure Stream Analytics supports Azure SQL Database as a source of input for reference data. You can use SQL Database as reference data for your Stream Analytics job in the Azure portal and in Visual Studio with Stream Analytics tools. This article demonstrates how to do both methods.

    Now that you have defined Azure SQL Database as a source for Azure Stream Analytics, you can then add Power BI on the scenario for the real-time streaming dashboard as explained here.