Forum Discussion

Sajid02's avatar
Sajid02
Icon for Helper I rankHelper I
2 years ago

Visualize live connection status (Success or Failed )

Hi Folks, 

I want to achieve and visualize Live connection refresh status of ADF pipeline whether it is Failed or Success in Real time.

Data Which I have :-



Sequence of Pipeline Activity :-


These are the 6 stages of Pipeline activity . I want to achieve result as in if Pipeline 1 refreshed it shows as Green only and rest part will be like Grey or White in color. Similarly when it goes to next stage it , 1st and second phase become green only and rest will be Grey.

If any activity failed in refresh - It shows red.

Like after 1st and 2nd phase if in 3rd phase pipeline failed in refresh , then 3rd stage should blink in red only.

Hope you guys understand conditions.

Pls help 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Sajid02 ,

    I think in Powerbi you can colorize data that is static. For what you mentioned in your description, I think that after you run the data, you can import the data into Powerbi and colorize it using Conditional formatting.

     

    Firstly I create a table as you mentioned.

    Then I create a measure and here is the DAX code:

    Color = IF(MAX('Table'[Status])="FAILED","Red","Green")

    Finally you will get what you want.

     

     

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.