DHIS and PowerBi

Resources - Ressources FAQ
1

I want to learn integration of DHIS data in PowerBi

2 Likes
2

Welcome @saleemirshad!

  • Open Power BI Desktop
  • Click Home > Get Data > Web
  • Paste the DHIS2 API URL
  • Enter your DHIS2 credentials (Basic Authentication)
  • If necessary, modify the API call in Advanced Editor to dynamically query the API
  • Use Power Query Editor to transform data
  • Add relationships, calculated columns, and measures
  • Create a data model (e.g., link indicators to metadata, periods, org units)
  • Use visuals like bar charts, tables, KPIs
  • Add filters for period, org unit, or program
  • Publish to Power BI Service for sharing with stakeholders.
  • Set up scheduled refresh** in Power BI Service
  • Use Gateway if you’re pulling data from a local source
  • Consider using Power Automate or a custom script to fetch DHIS2 data periodically and store it (e.g., in SQL or Excel)

I’m sure you can do it :clap:

2 Likes
3

Hi @saleemirshad !

Welcome to the community and thanks for sharing about your interest.

Thanks @HanyAly for sharing these steps. I’d also like to point out that @Mayamiko has shared some helpful guides in the community - check them out too. :slight_smile:

2 Likes
4

Hi @saleemirshad,

Thank you for expressing interest in integrating DHIS2 data with Power BI. Like @Gassim mentioned, I’ve written some articles on this topic. Building on what @HanyAly has shared, this is what you find in the articles:

  1. The first article, which you can find here, provides an introduction to integrating DHIS2 with Power BI. The related CoP post is available here.
  2. For a step-by-step guide on how to integrate DHIS2 with Power BI, you can read the article here. The corresponding CoP post is here.

If you’d like to chat more about this, please feel free to reach out. :smiling_face_with_sunglasses:

1 Like