Power BI: Displaying Realtime information in Power BI Dashboard using SQL Server

This video is a tutorial on how to display real-time data on a Power BI dashboard using a free version of Power BI desktop and Microsoft SQL Server Express. The video starts by introducing the topic and then explaining that there are various ways to display real-time data on a Power BI dashboard. The video goes on to explain that the real-time data will be displayed without using any paid application.

The video then demonstrates how to create a database table in Microsoft SQL Server Express, with two columns named "sensor one" and "sensor two" using decimal as the data type. These columns will store random information depicting data received and stored from sensors, and this information will be displayed on the Power BI dashboard in real-time. The table is saved as "sensors".

The video then demonstrates how to enter some data into the sensors table using an insert command to insert zeros in both columns. Next, the video shows how to connect Power BI desktop to SQL Server using the "Get Data" feature, select SQL Server database, enter the server's name and database containing the table, and select Direct Query as the data connectivity mode.

After connecting to the SQL server database, the video shows how to add a title to the dashboard using a text box visual and then add two gauge visuals for sensor one and sensor two. A gauge visual shows a single value as progress, in comparison with minimum, maximum, and target values. The video demonstrates how to add the sensor one and sensor two fields into the value area for the first and second gauge visuals, respectively.

Finally, the video explains that the dashboard is now linked to the SQL Server database but will not show the data in real-time. To enable real-time data, the video shows how to turn on the page refresh setting in format your report page. In conclusion, the video explains that by following the steps demonstrated in the video, the user can create a real-time data dashboard without using any paid application.

#PowerBI #realtimeData #SQLServer #dashboard #dataVisualization #dataAnalytics #Microsoft #tutorial

[srdouglas]

Parabéns, mostra obtendo informações de ações

[alvarogonzales-xpqw]

what information do you see?? can you have a example, in real time when i change manually one value in table on excel to comunicate on sql server. to visualite en power bi.

[SHAUNVINDA]

i do not have the refresh page option, any idea why?

[MoonShine-bscl]

Hi awesome explanation, please could you make a same video on how to refresh data from sql server by using power automate it would be very helpful. Thanks in advance

[mejdithabet]

Hello ! i didn't find auto refresh

[MoonShine-bscl]

Hi, it's great experience learning from you, please can you show me one example on the power bi dashboard where my source was Excel first and now the same dataset is changed to Sql database, how do i update the sql database for automatic refresh in power bi and also how automation can b done through the connected application in power bi. Thanks in advance, as this will help me.

[nglife]

how to publish this real time reports on Power bi cloud services so that clients can also see real time data for per second?

[MoonShine-bscl]

Hi i have one query, please can you make a video on cumulative percentage where for eg i have
A - 16% \B - 25%\ C - 35%\D = 0% /E = 56% /F = 60%
Example it should add 16+25+35+0+56+60 as result, but after 0% its not adding cumulative pls help

[beskal]

why my power bi don't have page refresh?

[MoonShine-bscl]

Hi Awesome, I have one request please could you make a video on connecting dataset through API to web / application and refreshing it.
It would b a new thing to learn for me... Thanks in advance