Integrate commcare with Power BI

[Nando Flores]

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.

[Jos van der Ent]

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