Integrate commcare with Power BI

(Nando Flores) #1

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.

0 Likes

(Jos van der Ent) #2

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. >
0 Likes

(Soha) #3

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

0 Likes

(Jumai Muhammed) #4

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.

0 Likes

(Tony) #5

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