Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 36 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 74 | |
| 66 | |
| 65 |