Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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.
You can refer these articles about Direct Quert and Live Connect:
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 Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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.
You can refer these articles about Direct Quert and Live Connect:
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 Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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.
https://sites.google.com/site/allisonkennedycv
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as 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 C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
@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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |