Connect ONA to PowerBI to analyze ODK Data

1. What is the problem? Be very detailed.
I am trying to connect ONA to my PowerBI desktop so that each time data is submitted, all I need to do is refresh and get the latest data without having to recreate everything.

2. What app or server are you using and on what device and operating system? Include version numbers.
I am using PowerBI desktop version 2.88.1385.0 (December 2020)

3. What you have you tried to fix the problem?
I have tried to use the web link, all that is showing is a list of the exported data. Another option that has worked is when I export the data and get the link of the exported data. Something I am avoiding....
4. What steps can we take to reproduce the problem?
Connect your form submission repository to PowerBI. Especially ONA/Enketo
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.

Hi @Mukombl
We're glad you're here. When you get a chance, please introduce yourself on this forum thread.

ONA has its own forum so it might be better to ask there.