Power BI: Displaying Realtime Boiler Plant Information in Power BI Dashboard using SQL Server
DescriptionWelcome back to another real-time simulation video. Today, we will create a real-time simulation of a boiler plant using SQL Server to store boiler information per second and display it in a Power BI dashboard.
To begin, let's start with SQL. In SQL Server, create a new database and give it a name. You can find your database in the object explorer.
Next, right-click on the database and create a new table without using any query. We will import data directly into the SQL Server database. Go to tasks and click on the "Import Flat File" menu item. Enter the location of your flat file and proceed through the import process.
Once your data is loaded successfully, refresh your database, and you'll see your table in the tables area. You can view the top 1000 rows to verify the table and data.
Now, open a new query in SQL Server. This query will create a blank table with all the columns of our Boiler table. We will use a loop to insert data from the main table into this blank table, simulating real-time monitoring.
The code will update one row per second, and we'll use a variable to keep track of the rows. We can test the code by temporarily adding a select command. It works perfectly for simulating boiler readings per second.
Now, let's connect to the SQL Server database in Power BI. Enter the server name and database name, ensuring you select "Direct Query" for real-time data. In the navigator window, select the boiler table and press the load button.
After loading the data, you'll find all the fields in the data pane on the right side, ready to create visuals. Start your dashboard by adding a text box visual with an appropriate title. Customize the font size, make it bold, and place it at the top of the screen.
Add visuals for various sensor data such as water flow rate, gas consumption, return water temperature, and more. Customize the visuals, set filters, and check the minimum and maximum values for each sensor.
Create measures and adjust the visuals accordingly. Don't forget to set up page refresh and the refresh interval for real-time updates.
For charts, add line charts to display data trends over time, using appropriate fields for the x and y axes. Apply filters and customize titles.
Finally, add a card visual for displaying the current time. Arrange your visuals on the dashboard, and your real-time simulation dashboard is complete.
Turn on page refresh, run the query, and observe the real-time simulation in action. We hope you found this tutorial helpful. Don't forget to like and subscribe for more tutorials and updates. Feel free to ask any questions or leave feedback in the comment section below. Thanks for watching!
Power BI File and CSV dataset: https://drive.google.com/file/d/1-WK9SSPi1lvqXAI8ARB3MqBE5qbUy99T/view?usp=sharing
Real Time Simulation,
Data Visualization Database Management,
Data Analytics Tutorial,
Tech How To,