Hands-On-Lab: Streaming Data From SQL Server To Power BI

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.

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.

Get weekly learning resources from SQLMaestros, right in your inbox. Subscribe to our Bulletins.