How to easily connect ODK to Power BI

Hello Fellow Aid, Development & Social Data Practitioners!

Are you wondering how you can easily link the data you’ve collected using ODK Collect into Power BI? Well, ODK Central makes it pretty easy! ODK Central provides an OData feed, to easily transmit data from ODK into Power BI at (pretty much) the click of a button! Using a few basic steps - copying over a URL, and expanding a few columns in Power Query - then it’s done! Let me show you how in this tutorial!

⬇️ You can download FREE XLSForm I use in the video here:
⭐Are you new to ODK and ODK Central? Click here to check it out:

Link to Forum Discussions: Here are a few Forum Discussion Topics that discuss ideas and challenges about connecting ODK to Power BI:

🍒 WANT TO JOIN THE HUMANITARIAN DATA SOLUTIONS MAILING LIST?

✅Interested in enrolling your staff in training courses with Humanitarian Data Solutions? ►

✅Need help from Humanitarian Data Solutions with a consulting project? ►

If you liked this video, please give it a thumbs up 👍, subscribe, share it with your friends.

✅ SUBSCRIBE TO OUR YOUTUBE CHANNEL:

CONNECT WITH HUMANITARIAN DATA SOLUTIONS:

[MuhammadNasserAl-Harazi]

thank you Janna you are the best female teacher I have seen

[pravinsingh]

Thanks! I have a scenario, wherein, data collection is happening in ODK, and want to show this in Power BI in the browser. Also, I want specific data that can be seen by specific users. Does this require all users to have Power BI license?

[anthonygikuri]

Thank you Janna for another great video.

[ricardovargas]

Thanks for the video Janna. I have been using Kobo as a server to collect the surveys I do with ODK for years. It has never been very clear to me the advantages of using ODK Central over Kobo. Maybe later on you could develop something on this topic.

[ABDULAIOSMANKAMARA-ck]

I want you to help how to go about this whole thing ASAP

[shepherdmaverudze]

Well explained. Do you have an idea on how to connect DHIS2 to powerB1 again