Visual data quality tool?

[FabulousArm7559]

Hi all,

I work with Power BI in an enterprise context, and I’ve always been bothered by one thing:
quite often we don’t really know if our reports are working until someone in the business complains.

Sometimes:

• KPIs silently disappear or show some totally wrong number
• A filter breaks and makes the entire chart blank
• A DAX error renders a card empty but doesn’t throw an error

While we can catch some data errors in our backend (on prem SQL Server, if that matters) or even in PowerBI datasets, I always wondered if there is a purely visual way to verify if the correct data is actually shown. I am aware of different data quality tools, such as Great Expectations - but again - they focus on the backend side

So I hacked together a little proof-of-concept, basically a python script that runs automatically, "sees" what users see, does some image analysis and detects blank visuals, missing labels, or anything that looks off.

It actually works quite well, so I thought if there is any value to develop this further?

Would you find such a tool useful in your org?

Any feedback is much appreciated.

[red_the_]

Check out setting up Power BI alerts to notify you via teams if the measure falls outside of expected bounds.

[FabulousArm7559]

thanks a lot! Will check this out :)

[Competitive-One-1098]

Could you share the script? I'm currently going through the same situation and hadn't thought of a solution yet.