Streaming Data From SQL Server To Power BI

Description

In this lab, we’ll learn to implement real time streaming dashboards in Power BI. Real time streaming in Power BI can be done two ways, using the Power BI REST API or Pubnub. In this lab, we’ll implement real time streaming using Power BI REST API. In the first exercise, we’ll create a Streaming Dataset to hold the streaming data and a Dashboard to visualize the streaming dataset. In the second exercise, we’ll create a C# console application to stream data from SQL Server to the Power BI streaming Dataset using the Power BI REST API. In the third exercise, we’ll run the application created in second exercise to see the real-time data streaming in action.

Exercise 1: Creating A Streaming dataset
Exercise 2: Streaming Data using API
Exercise 3: Real Time Dashboard in Action