Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 th...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    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:

    1. Use DirectQuery in Power BI Desktop 
    2. Power BI connectivity modes 
    3. 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 Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

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