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.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
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.