Forum Discussion

ram142more's avatar
ram142more
Frequent Visitor
9 days ago

Text not shown in activator Alert msg

Hi Team,

I am trying to show failed pipeline in activator with failed pipeline name but it wont show any variable after entering @ for Pipeline.

Can anyone guide me how to show text in activator alert msg, please?

9 Replies

  • ram142more's avatar
    ram142more
    Frequent Visitor

    Hi Mauro89​ ,

    I think the document link share by you is to trigger another Fabric Activity not Activator.
    As simple, we have 10 pipeline which are running in ADF and create view in databricks to see list of pipeline are failed or success. base on that view we want to create alert for failed pipeline. As i am able to create alert base on count of failed pipeline through realtime monitoring dashboard. 

    but won't show the pipeline name because Alert create only on KPI, cards.

  • ShivekMaharaj's avatar
    ShivekMaharaj
    Impactful Individual

    Hi ram142more​,

    Mauro89​'s point makes sense for a KPI/card alert, but I think the important limitation is actually the data being passed into Activator.

    When an alert is created from a Power BI visual, Activator uses the visual's underlying query and turns the returned dimensions/measures into objects and properties.

    So if your card only contains something like:

    Failed pipeline count = 3

    then PipelineName is not part of that query, which is why typing @Pipeline . . . does not offer it. Upgrading the alert in Activator cannot add a field that was not present in the original monitored data.

    I would try changing the alert source rather than the message itself. Microsoft now supports Activator alerts on table and matrix visuals, with the rule evaluated per row.

    For example, create a table containing:

    PipelineName | Status | LastRunTime

    and create the alert from that visual for rows where Status = Failed. PipelineName then becomes part of the data Activator is monitoring and can be included as context in the notification.

    Activator actions support referencing available properties with @ in the message.

    So I would keep the KPI card for the summary view, but drive the actual failure notification from a row/dimension-based visual or query that includes the pipeline name.

    • ram142more's avatar
      ram142more
      Frequent Visitor

      Hi ShivekMaharaj​ ,

      Thanks for the response.

      I am using 
      Alert not allowed to create based on Table as you mentioned where i have all 3 columns. 
      It only allowed from KPI card where it only picked up numeric number only parameter.
      Please check in below screenshot. 

       

  • Kagiyama_yutaka's avatar
    Kagiyama_yutaka
    Responsive Resident

    PipelineName isn’t in the KPI/Card query, so Activator has no way to reference it. If you need PipelineName in the alert message, you have to create the alert from a table or matrix that actually includes PipelineName, Status, and LastRunTime.  Use the KPI for the summary, and use the table for the alert. That’s the right setup.

  • v-kathullac's avatar
    v-kathullac
    Community Support

    Hi ram142more​ ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

    Regards,

    Chaithanya