From the CommCare team:
It looks like Excel’s Power Query doesn’t properly handle basic authentication. See this article:
You can get around this by adding your own custom power query expression.
- In Excel, go to New Query, but choose Other, Blank Query
- In the query editor, then click on View, Advanced Editor
- Then paste in the following:
Source = Web.Page(Binary.Buffer(Web.Contents(“https://www.commcarehq.org/a/goal-sierra-leone/reports/export/saved/download/e54dcc5e1ec5d511ebbc1c09938460da/”)))
Note that the URL needs to end with a slash. Excel will prompt you to enter your username / password via Basic Auth then. You can then use the query editor to choose the data you want.
From: firstname.lastname@example.org [mailto:email@example.com] On Behalf Of Javariya Aamir
Sent: Thursday, May 12, 2016 5:53 AM
Subject: Re: PowerBI Integration
I am having the same issue. As Ralph has reported that commcare integration is possible with power BI, can someone please update on how it is possible? Because I am getting the same authorization error on all options. much thanks
On Friday, September 25, 2015 at 10:49:30 PM UTC+5, Ralph Myers wrote:
I am currently using Microsoft PowerBI for a lot of our visualizations and reporting. We are looking to use CommCare for the majority of our programmes, however whenever I have tried to import data, it says my account is not authorized. I have no problem doing the same following the instructions for creating Excel dashboards. PowerBI allows for a number of different authentication methods including Basic and using an API Key, neither of which work. I’m not sure if this is a CommCare or PowerBI issue, but I thought I would try CommCare first.
It would be great to be able to integrate PowerBI with CommCare as they are working hard to compete with solutions such as Tableau (PowerBI is waaaay cheaper) and really see this as the way forward to replacing Excel Dashboards.
You received this message because you are subscribed to a topic in the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/commcare-users/iziM4ouhIgY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to firstname.lastname@example.org:email@example.com.
For more options, visit https://groups.google.com/d/optout.
Disclaimer GOAL: This communication contains information which may be confidential, personal and/or privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, forwarding, copying or use of this communication or the information in it is strictly prohibited. Any personal views expressed in this e-mail are those of the individual sender and GOAL does not endorse or accept responsibility for them. Prior to taking any action based upon this e-mail message, you should seek appropriate confirmation of its authenticity. GOAL is a registered charity in Ireland: Charity Reg No: 20010980, CHY 6271, GOAL (International), trading as GOAL UK, in the United Kingdom: Charity Reg No: 1107403 and GOAL USA Fund in the US as a 501©(3) not-for-profit organization and contributions are deductible to the fullest extent allowed by the law.