Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Brian1
New Member

Connecting to ODK Aggregate as data source

Hello,

I am using Open Data Kit (ODK) for data collection on Android smartphones and the data repository is ODK Aggregate. If anyone has used ODK Aggregate as a data source for Power BI I would very much appreciate your insights on how to make this link.

Thanks!

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

Hi all,

 

Founder and CEO of ODK here.

 

ODK Aggregate has reached end-of-life status and is no longer being updated. See https://forum.getodk.org/t/aggregate-is-no-longer-being-updated/33742 for more.

 

ODK Central, its replacement, has native support for Power BI (and Excel) via our OData feed. See https://docs.getodk.org/central-submissions/#connecting-to-submission-data-over-odata to learn how. 

 

If you have any more questions, our community forum at https://forum.getodk.org/c/support/ is a great place to ask.

 

Yaw

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Hi @Brian1,

I am not familiar with ODK Aggregate, and I haven’t found any direct way to use ODK Aggregate as a data source in Power BI.

However, as other post, you can consider to export data to CSV files, and connect to CSV files from Power BI Desktop, create reports in Desktop and publish them to Power BI Service. For more details about publishing from Power BI Desktop, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-upload-desktop-files/ .

Moreover, if you deployed ODK Aggregate locally on a Tomcat server backed with a MySQL or PostgreSQL database server. You are able to connect to the MySQL or PostgreSQL database from Power BI Desktop.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Matt_Langeman
Regular Visitor

I have used ODK in the past and am somewhat familiar with ODK Aggregate. However, I have not tried connecting data from ODK Aggregate directly into Power BI. Do you need something other than the Export to CSV/KML/JSON functionality that is built into Aggregate?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors