Forum Discussion
show a single live value
Hi together,
I'am new at Power Bi. I want to show one single value, from my database, which represents the measurement of a sensor. The value is updated every second. I just want to show the value with nothing around.
How can I do that?
Hi Anonymous ,
There are two connection modes that can get live value: Direct Query and Connect live. It depends on which database you have connected.
If your database is like SQL server, you can use Direct Query mode to connect. If your database is a SSAS Tabular, you can use Connect Live to connect. Please note that, when using Connect Live mode, the modeling is limited in power bi desktop.
Connect to SQL ServerConnect to SSAS tabular
You can refer these articles about Direct Quert and Live Connect:
- Use DirectQuery in Power BI Desktop
- Power BI connectivity modes
- DirectQuery, Live Connection or Import Data? Tough Decision!
In addtion, here is a table that shows the data sources that Power BI supports for datasets:
You can refer this microsoft document for more details about power bi supported data source: Power BI data sources
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- nandukrishnavs
Community Champion
Anonymous
You have to use the DirectQuery method for connecting the database.
Then you have to write a DAX measure to calculate the measurement of sensor value.
You can use the card visual to represent this data. Next step, publish this report to the workspace and pin this visual to the dashboard. You can see live data there.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂T
- amitchandak
Super User
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos. - AllisonKennedy
Hi Anonymous
Welcome to Power BI!
What you are looking for is absolutely possible.
Have you read much about live dashboards? https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming
It depends on how you connect to the database, and you will need to have some gateway and security setup so that the Power BI service can access the real-time data in the database and update the dashboard live.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
v-yingjlCommunity Support
Hi Anonymous ,
There are two connection modes that can get live value: Direct Query and Connect live. It depends on which database you have connected.
If your database is like SQL server, you can use Direct Query mode to connect. If your database is a SSAS Tabular, you can use Connect Live to connect. Please note that, when using Connect Live mode, the modeling is limited in power bi desktop.
Connect to SQL ServerConnect to SSAS tabular
You can refer these articles about Direct Quert and Live Connect:
- Use DirectQuery in Power BI Desktop
- Power BI connectivity modes
- DirectQuery, Live Connection or Import Data? Tough Decision!
In addtion, here is a table that shows the data sources that Power BI supports for datasets:
You can refer this microsoft document for more details about power bi supported data source: Power BI data sources
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
