Integrate commcare with Power BI

Can anyone please tell me how to integrate commcare into Power BI, so I can
get information from commcare forms using a web connection in Power BI?
I need this so I can use the data in the forms and refresh the analysis in
power BI, without having to download the excel workbook each time.
If you could please tell me how to do this, I would really appreciate it.
Thanks.

You can link PowerBi by adding this to the ‘source’
= Web.Page(Binary.Buffer(Web.Contents(“link”)))
Link you would need to replace with the link found at excel dashboard
integration.
Be aware in my case I had to replace http to https

··· On Saturday, 25 February 2017 02:26:39 UTC+1, Nando Flores wrote: > > Can anyone please tell me how to integrate commcare into Power BI, so I > can get information from commcare forms using a web connection in Power BI? > I need this so I can use the data in the forms and refresh the analysis in > power BI, without having to download the excel workbook each time. > If you could please tell me how to do this, I would really appreciate it. > Thanks. >

Hi all,

I’m facing an issue with trying to integrate CommCare with PowerBI. I never recieve an “edit credentials” message when I enter the source address as follows:

Web.Page(Binary.Buffer(Web.Contents(“https://www.commcarehq.org/a/billy-excerpt/data/export/custom/dailysaved/download/c70eeabde28c1b1d9bab9b382bc95cfc/”)))

Does anyone know how I can fix this?

Thanks,
Soha

Hi Soha,

Were you ever able to resolve this? I have this same issue and also when i share the Power BI files with other users who actually need the data, it brings up errors whenever they try to refresh.

Hi @JayH,

were you able use the following workflow to get it to work?

Are you sharing the .pbix file or are you sharing the link to the report? In order for the above workflow to work you’ll need to build the report in power bi desktop, upload the report to powerbi.com and then setup a gateway connection (on a server or on a personal computer) in the online report settings that’ll allow it update.

-Tony

1 Like

Hi @ttseng,

Yes i was able to use the workflow but i encountered issues when i tried to link the live data feed coming from Commcare with another dataset that i had uploaded on the cloud. I tried another way by giving users access to the other file on the web as well but everytime they refreshed it brought up errors so i decided to put as many cases inside Commcare as i could and that resolved the issues for now. Its not a good solution in the long run and i don’t think Commcare can handle importing form data as i have a ton of data collected outside of Commcare that needs to be integrated.