Forum Discussion

sirros_iot's avatar
sirros_iot
Helper III
8 years ago
Solved

Create virtual table into Push Streaming Dataset

Hello all!

I'm having trouble with this, so..
I would like to know if there is a way to use virtual table, like SUMMARIZE into measures if the data comes from streaming.
Here is the link... If you could tell me what I can't use( like calculated columns) in my report I would appreciate!
Real-Time Streaming, Push

Thank you all,

Diego

  • Hi sirros_iot,

     

    Summarize() is function through you can create a new table in your data model, not a measure created in report level. In addtion, modeling is not possible on a streaming dataset, since the data is not stored permanently. For a push dataset, you can use the update dataset/table REST APIs to add measures and relationships. 

     

    So to update table, calculate column or measure, I would recommend you to use rest apis to achieve your requirement.

     

    Regards,

    Jimmy Tao

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi sirros_iot,

     

    Summarize() is function through you can create a new table in your data model, not a measure created in report level. In addtion, modeling is not possible on a streaming dataset, since the data is not stored permanently. For a push dataset, you can use the update dataset/table REST APIs to add measures and relationships. 

     

    So to update table, calculate column or measure, I would recommend you to use rest apis to achieve your requirement.

     

    Regards,

    Jimmy Tao