Visualize live connection status (Success or Failed )

[Sajid02]

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 

[Anonymous]

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.