Skip to content

DGA Fault Triangle in Power BI with ReadyViz

Datadriven.pro works with ReadyViz Power BI custom visuals. One very specific example is ReadyViz DGA Fault Triangle, a custom visual for transformer dissolved gas analysis in Microsoft Power BI.

ReadyViz DGA Fault Triangle in Power BI
ReadyViz DGA Fault Triangle for transformer reporting in Power BI.

Dissolved gas analysis is an engineering topic. But the reporting audience is often bigger than the engineering team. Asset managers, maintenance planners, reliability teams and management need to see transformer condition in a way that can be discussed together with asset, work order and operational data.

Problem: DGA results stay in specialist files

Lab results, engineering notes and manual reports can be correct, but they are often disconnected from the BI reporting environment. This makes fleet comparison, trend review and management reporting harder than necessary.

Power BI can bring the DGA view next to asset metadata, sample dates, maintenance plans, location, criticality, inspection history and KPIs. The ReadyViz visual adds the triangle interpretation to this report model.

! KEY take away !

  • The visual supports Duval Triangle 1, Triangle 4 and Triangle 5.
  • Segment colors, markers, legends and labels can be formatted for the report.
  • Connector lines and arrowheads can show movement between samples over time.
  • The same report can combine DGA interpretation with maintenance and asset data.
  • The visual helps interpretation, but it does not replace engineering judgement.

Data requirements

Each point should represent one DGA sample. Gas values should be numeric and the units should be consistent. The exact gas fields depend on the selected Duval Triangle method. For business reporting I would also add transformer ID, sample date, region, fleet, maintenance status and maybe criticality.

This is important because the triangle alone is only part of the story. In most real reports users want to filter by transformer, compare dates, and see if there is already an open work order or inspection planned.

Where it helps

  • Transformer fleet monitoring
  • Periodic dissolved gas analysis review
  • Maintenance planning
  • Reliability and asset health dashboards
  • Reporting for utilities and industrial sites
  • Standardized reporting across several business units

What I would check before publishing

  • Are all gases for the selected triangle method available?
  • Are all values using the same unit?
  • Is the sample sequence correct if connector lines are used?
  • Can the report user see asset context and not only the triangle?
  • Is there a clear note that this is an interpretation aid and not a replacement for engineering review?

That last point matters. DGA visuals are very useful, but they should sit inside a bigger transformer condition workflow.

Important

Duval Triangle methods are for fault classification, not fault detection. ReadyViz DGA Fault Triangle helps present and compare the samples in Power BI, but laboratory quality checks, transformer expertise and safety procedures are still required.

How Datadriven.pro can help

Datadriven.pro can help build the Power BI model, prepare the DGA data, add the asset and maintenance context and configure the ReadyViz visual for a report that management can actually use.

Views: 2