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

Рет қаралды 43,704

Күн бұрын

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.
• Power BI: Displaying R...
#PowerBI #realtimeData #SQLServer #dashboard #dataVisualization #dataAnalytics #Microsoft #tutorial

Пікірлер: 54

@AiBusiness-io2sm Күн бұрын

When I try to connect to SQL Server in Power BI I get this error message: CANNOT CONNECT Details: “Microsoft SQL: A connection to the server was successfully established, but an error occurred during the login process (provider: SSL Provider, error: 0 - The certification chain was issued by an untrusted entity).”????

@rajkumarrajan8059 10 ай бұрын

This is lovely!!!

@virtual_school 4 ай бұрын

Thanks 😊

@MoonShine-bs6cl 10 ай бұрын

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

@virtual_school 10 ай бұрын

Sure. I will do a tutorial on using power automate with bi.

@virtual_school 10 ай бұрын

Is this what you were looking for? kzfaq.info/get/bejne/r7Njar2Tmr-vZ5c.html

@khaledelsafy Жыл бұрын

excellent

@virtual_school Жыл бұрын

Thank you sir.

@telugupadyalu...6927 Жыл бұрын

nice ..very nice

@MoonShine-bs6cl 6 ай бұрын

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

@virtual_school 6 ай бұрын

Sure, why not. I will be glad to. Could you pls help me understand. Which API. What kind of web/application? Thanks

@MoonShine-bs6cl 6 ай бұрын

@@virtual_school I have only heard about API which connects datasets like json to power bi, you can use any web database online for experiment, as I just want to know how this API works nd makes the dataset refresh... Thank u

@virtual_school 6 ай бұрын

Did you see this video? kzfaq.info/get/bejne/eNl9d6dirMzLn6c.html In this tutorial we connected power bi to world bank database, using their API. Is this what you are looking for?

@MoonShine-bs6cl 6 ай бұрын

@@virtual_school yes I have seen but i have not understood, how this API works and should me schedule a refresh on this link that every day i get fresh data updated, and In this video I don't want country seperate query and few categories query is connected, in power bi microsoft you have Refresh dataset option using API... It starts (https:API.powerbi )etc, how do i use this please can u make a demo end to end...

@SHAUNVINDA 4 ай бұрын

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

@virtual_school 4 ай бұрын

Probably you selected Import instead of DirectQuery on windows where it asks for server name.

@wick_bourne Ай бұрын

I need your assistance.... I think you must have forgetten something to mention @08:45. Because when i execute the sql query, Sensor 1 displays SUM value instead of latest value of sql table's SENSOR 1.

@virtual_school Ай бұрын

As per my setup. Sensor one is just count down, so it shows maximum value, while sensor two is set to show average value. See @8:28. Did you change them from sum to maximum, and average?

@wick_bourne Ай бұрын

@@virtual_school This is one way but how to view the latest value in SQL table using SQL query or something?

@virtual_school Ай бұрын

For that you need another timestamp column and based on that you will need an sq query such as "select top 1 yourcolumn from yourtable order by timestampcolumn desc", or similar other query.

@wick_bourne Ай бұрын

@@virtual_school Yeah correct. For that matter, we can also create and go with id column as well.

@alvarogonzales-xp9qw 10 ай бұрын

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.

@virtual_school 10 ай бұрын

Sorry I could not understand your question.

@MoonShine-bs6cl 11 ай бұрын

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.

@virtual_school 11 ай бұрын

First your data source was Excel, but now it is SQL. So excel is now irrelevant. You are connected to SQL server database, which is already automated. Data is updated into SQL server database from some input method. So all you have to do is turn on the page refresh in Power BI (Data should be connected through Power Query). All my realtime examples including this one uses this method.

@MoonShine-bs6cl 11 ай бұрын

@@virtual_school Ok so i can refer your real time examples of SQL database which you hv used and how do i automate it that when it's connected to SQL server it should get refresh automatically. Thank you so much😊

@virtual_school 11 ай бұрын

1. Make sure it is connect to the SQL server using "DirectQuery" method. 2. Make sure that the "Page Refresh" in turned on in Power BI, and time is set according to your requirement All of this is covered in the tutorials.

@user-zm7qi7et3r 6 ай бұрын

Hello, I cant seem to find the refresh button on my power bi desktop app, I am sure my dad is connected through "DirectQuery" but i cant refresh the page. if you could quide me in this.@@virtual_school

@kaylacharity1429 5 ай бұрын

Will this report show real time data in power Bi service?

@srdouglas1026 Ай бұрын

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

@virtual_school Ай бұрын

How can we help you?

@beskal80 Жыл бұрын

why my power bi don't have page refresh?

@virtual_school Жыл бұрын

Probably because you are not connected to a supported database. Even if you are connect to SQL and choose import instead of directquery as data connectivity mode, the referesh page option will not be available. Visit this page for list of directquery supported data sources. learn.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

@beskal80 Жыл бұрын

@@virtual_school thank you..now i can see it

@mejdithabet6145 Жыл бұрын

@@beskal80 How did you resolve the pb plz ?

@MoonShine-bs6cl 7 ай бұрын

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

@virtual_school 7 ай бұрын

I am having difficulty understanding your question. Please share a sample file. or if the problem is in a formula/function, please share that.

@MoonShine-bs6cl 6 ай бұрын

I got this thank u

@mejdithabet6145 Жыл бұрын

Hello ! i didn't find auto refresh

@virtual_school Жыл бұрын

Did you connect to the data through DirectQuery? and what type of data source you are using. It works only with specific databases such as SQL Server.

@mejdithabet6145 Жыл бұрын

@@virtual_school Yes. Last one i've in page Format is Filter Cards

@virtual_school Жыл бұрын

If Page Refresh option is not there, that means either you are not connected to the compatible data source, or you did not choose the DirectQuery during connection. I cannot think of any other reason.

@nglife8710 Жыл бұрын

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

@virtual_school Жыл бұрын

You will need a Power BI subscription for that.

@nglife8710 Жыл бұрын

@@virtual_school I have power bi pro subscription as well. Do i have to set or enable fixed interval refresh for every page on power bi service as well or is there any way to get data automatically updated after some seconds?

@virtual_school Жыл бұрын

@@nglife8710 Sorry can't help you with that, we are not using pro or premium right now. Only Power BI Desktop.

@felipeantoniomoraramos6905 Жыл бұрын

@@nglife8710 Have you solved this? I have the same question

@nglife8710 Жыл бұрын

@@felipeantoniomoraramos6905 yes just go with power bi premium and direct query approach it will work

@ruwanc2003 Ай бұрын

This is not realtime, one second refresh

@virtual_school Ай бұрын

Yes. I hope you did your cost and benefit analysis if you want to go for "real" real time and avoiding just one second of latency?

@ruwanc2003 Ай бұрын

@@virtual_school yes, I need realtime, datastreaming, can you do that?

@virtual_school Ай бұрын

I do not use most of the stuff required for realtime datastreaming, so cannot do that right now. For me, directquery is the perfect solution as I can produce near to realtime reports on large databases without paying anything, facing any limitations and building complex models.