Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Wonderware INSQL Historian

i am using wonderware historian which based on INSQL(industrial SQL ) bewlow query to retrive certain tag ('mesCANFiller02.stOperatingState') i have to specifiy startdata and Enddata in my query as ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Anonymous,

     

    It is impossible to send slicer selection data to query editor as filter parameter.

     

    Date levels:

    Database -> Power query(query table, query parameter, custom function) -> Data model(calculated column/table, RLS) -> Data view(measure, visual , slicer)

     

    Notice: Parent level can affect child but child is impossible to affect its parent.

     

    For your scenario, you can only use query parameter to get dynamic result table.

    Deep Dive into Query Parameters and Power BI Templates

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

It is impossible to send slicer selection data to query editor as filter parameter.

 

Date levels:

Database -> Power query(query table, query parameter, custom function) -> Data model(calculated column/table, RLS) -> Data view(measure, visual , slicer)

 

Notice: Parent level can affect child but child is impossible to affect its parent.

 

For your scenario, you can only use query parameter to get dynamic result table.

Deep Dive into Query Parameters and Power BI Templates

 

Regards,

Xiaoxin Sheng