How to Connect Ona to Power Bi?

574 views
Skip to first unread message

thaty...@gmail.com

unread,
Sep 14, 2018, 11:03:16 AM9/14/18
to Ona Community
Hello,
I want to connect the data collect by ODK and that is in the Ona server to Power Bi, so I can publish dashboards that updates in real time. The problem is that I only found Apps to connect to Tableau, Google Sheets and others.
How Can I connect to Power Bi?

Thanks.

Samson from Ona

unread,
Sep 17, 2018, 6:01:22 AM9/17/18
to ona-co...@googlegroups.com

Sent to thaty...@gmail.com and ona-co...@googlegroups.com

Hello,

Unfortunately we haven't integrated with Power BI yet. This is a feature that's not on our short term road map. Please let us know if this is a feature you're willing to fund development for and we can prioritize it. We build features according to our users' needs.

However, you can opt to use Webhooks to Create an application or service that will receive the data sent from the webhook. Every time a submission is received on Ona data, it is sent to the app. The application will then push the data to Power BI. Please have a look at this documentation for more information on how webhooks work. 

Please let me know if you have further questions

Regards,
Samson

See our community forum & help site for more information!

--
Samson Samson from Ona

--
Collect, Analyze and Share Data - https://ona.io/
---
You received this message because you are subscribed to the Google Groups "Ona Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.
To post to this group, send email to ona-co...@googlegroups.com.
Visit this group at https://groups.google.com/group/ona-community.
To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/c319b0c7-a36f-4817-988f-bd35acea5795%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

intercom

Samson from Ona

unread,
Sep 17, 2018, 6:01:23 AM9/17/18
to ona-co...@googlegroups.com

kedir shemsu

unread,
Sep 7, 2020, 5:20:59 PM9/7/20
to Ona Community
Dear Samson,

I want to connect the data from ONA to Power BI to produce dashboard. I have seen in your previous email of the group that ONA can't be connected to Power BI directly.
Is there any development on ONA in this regard? 

Thank you in advance for your support.

Brian from Ona

unread,
Sep 8, 2020, 3:09:59 AM9/8/20
to ona-co...@googlegroups.com

This message was sent to the following 2 people: kedir shemsu, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello,

Unfortunately we haven't integrated with Power BI yet. This is a feature that's not on our short term road map. Please let us know if this is a feature you're willing to fund development for and we can prioritize it. We build features according to our users' needs.

Regards,
Brian

See our community forum & help site for more information!
Brian Brian from Ona
On Tue, Sep 8, 2020 at 12:21 AM, "kedir shemsu" <k.sh...@gmail.com> wrote:

Dear Samson,


I want to connect the data from ONA to Power BI to produce dashboard. I have seen in your previous email of the group that ONA can't be connected to Power BI directly.

Is there any development on ONA in this regard?


Thank you in advance for your support.

On Monday, September 17, 2018 at 1:01:23 PM UTC+3 Samson from Ona wrote:

Sent to thaty...@gmail.com and ona-co...@googlegroups.com

Hello,

Unfortunately we haven't integrated with Power BI yet. This is a feature that's not on our short term road map. Please let us know if this is a feature you're willing to fund development for and we can prioritize it. We build features according to our users' needs.

However, you can opt to use Webhooks to Create an application or service that will receive the data sent from the webhook. Every time a submission is received on Ona data, it is sent to the app. The application will then push the data to Power BI. Please have a look at this documentation for more information on how webhooks work.

Please let me know if you have further questions

Regards,
Samson

See our community forum & help site for more information!

--

On Fri, Sep 14, 2018 at 06:03 PM, "thaty...@gmail.com" <thaty...@gmail.com> wrote:

Hello,
I want to connect the data collect by ODK and that is in the Ona server to Power Bi, so I can publish dashboards that updates in real time. The problem is that I only found Apps to connect to Tableau, Google Sheets and others.
How Can I connect to Power Bi?

Thanks.

--
Collect, Analyze and Share Data - https://ona.io/
---
You received this message because you are subscribed to the Google Groups "Ona Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.
To post to this group, send email to ona-co...@googlegroups.com.
Visit this group at https://groups.google.com/group/ona-community.
To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/c319b0c7-a36f-4817-988f-bd35acea5795%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Collect, Analyze and Share Data - https://ona.io/
---
You received this message because you are subscribed to the Google Groups "Ona Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.

Wash ways

unread,
Sep 20, 2020, 10:43:03 AM9/20/20
to Ona Community
no powerBI integration??? that is really disappointing given how many orgs are using this platform these days.

Please can you give a walkthrough of how we can work around this?

is exporting through RapidPro and then using their API an option?

Wash ways

unread,
Sep 24, 2020, 12:51:42 AM9/24/20
to Ona Community
Dear all,

I figured it out. Its quite simple to connect ONA to powerBI... unfortunately there is just no clear guidance on how to do it on ONA site yet... Seems you dont need to have the app registered either.

in powerBI go to add new blank query.

'= Json.Document(Web.Contents("https://api.ona.io/api/v1/data/######")) '

replace ###### with your form ID

go to 'data source settings'

set authentication to 'basic'

add username and password.



simple... dont know why it didnt work for me the first few times i tried...

Brian from Ona

unread,
Sep 24, 2020, 4:03:42 AM9/24/20
to ona-co...@googlegroups.com

This message was sent to the following 2 people: Wash ways, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello,

Thank you so much for the information. We are glad that this is working on your end.

Regards,
Brian

See our community forum & help site for more information!

Brian Brian from Ona
On Thu, Sep 24, 2020 at 07:51 AM, "Wash ways" <wash...@gmail.com> wrote:

Dear all,


I figured it out. Its quite simple to connect ONA to powerBI... unfortunately there is just no clear guidance on how to do it on ONA site yet... Seems you dont need to have the app registered either.


in powerBI go to add new blank query.


'= Json.Document(Web.Contents("https://api.ona.io/api/v1/data/######")) '


replace ###### with your form ID


go to 'data source settings'


set authentication to 'basic'


add username and password.




simple... dont know why it didnt work for me the first few times i tried...

On Sun, Sep 20, 2020 at 05:43 PM, "Wash ways" <wash...@gmail.com> wrote:

no powerBI integration??? that is really disappointing given how many orgs are using this platform these days.


Please can you give a walkthrough of how we can work around this?


is exporting through RapidPro and then using their API an option?




On Tuesday, 8 September 2020 at 13:39:59 UTC+6:30 Brian from Ona wrote:

This message was sent to the following 2 people: kedir shemsu, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello,

Unfortunately we haven't integrated with Power BI yet. This is a feature that's not on our short term road map. Please let us know if this is a feature you're willing to fund development for and we can prioritize it. We build features according to our users' needs.

Regards,
Brian

See our community forum & help site for more information!

Moteb Marei

unread,
Mar 5, 2021, 1:09:28 PM3/5/21
to Ona Community
Dear @ Wash ways :
Thanks a lot for the information you shared.... but once i do the steps you provided I get the data like this:

data.view.quiry.png
 That I am not able to do any analysis or visualizations on it. any recommendations, please?  
Reply all
Reply to author
Forward
0 new messages