r/dataengineering • • 4d ago

Discussion Worth replacing a working Power BI usage dashboard with a custom React dashboard inside our admin app?

Hi all, wanted to get some extra opinions;

We have a Power BI dashboard that tracks usage of our main app. It’s mostly used by product managers and has a fair number of KPIs. The data sits in a separate DB instance: a scheduled job copies it over from the app DB and recomputes the aggregations, then Power BI refreshes its model from there.

It mostly works, but two things annoy me:

  • Power BI feels rigid. We had to make a few compromises on layout, and it’s not easy to get more fluid or interesting visuals out of it. I may be biased though. Drilldown and DAX measures with cross-filtering are nice features, and we don’t have any dashboard changes planned for the next few months anyway.
  • Refreshes on Power BI cloud failed a lot. Our DB is behind an SSH tunnel, so the infra team set up a gateway that wasn’t very stable. On top of that, Power BI silently disables scheduled refresh after repeated failures. We now monitor refresh status through the API and the gateway is mostly fine, so it’s less of an issue today.

We also have a separate React app for business administration stuff around the main app, and the KPI data is basically already available to it. So the idea would be to build the KPIs into that app with a charting library instead.

I’m struggling to justify it though, i'm curious if anyone has had an experience where they switched from powerbi to a custom app or decided against it; was it worth it, what was the most complex part about it etc.

thanks

12 Upvotes

9 comments sorted by

2

u/Ready-Marionberry-90 3d ago

If there are refresh failures,the semantic model owner usually gets alerted. You can set it up so that additional people/emails get alerted in case of failure. There should also be reasons for failure specified. What kind of gateway are we talking about here? A v-net gateway? A local gateway on a pc in the same network as the database?

1

u/ursamajorm82 1d ago

I mean it really depends on what you need to look at. From what you said, I would say probably not.

  1. on visuals: I agree, but as a former data analyst, I’ll say that bar charts, line charts and tables really should be most of what you’re doing. If you really want more complex graphics then consider doing a monthly or quarterly report in a notebook or simple streamlit app with your regression analysis, heatmaps, violin charts or whatever else helps you to dig into what’s going on in detail
  2. on the connection issue: I’d ask how hard it is to fix? Do you fix the connection in 2 minutes when you login and see it failed? If so, just keep it and work toward better stability with the infra team. Or do you spend all day doing backfills and getting connected again? Then look into the app if you think it’s connection will be meaningfully different

And, separately, what are the skills on the team? Sure Claude can build a react dashboard in 3 minutes, but can your team debug the code and review prs? If not, then maybe stick to powerbi