Refresh works on desktop but fails on web app (Data source = Web, API)

[Simont]

Hi,

I have a report with 4 data sources:

1. Mobile Action: Web API (Credential Type: Anonymous, API Key in the request as follow: Json.Document(Web.Contents("https://api.mobileaction.co/XXXXXXX/XXXXXX/XX?token=API_KEY"))
2. Appfigure: Web API (Credential Type: Basic, API Key in the request as follow: Json.Document(Web.Contents("https://api.appfigures.com/v2/reports/sales?client_key=API_KEY"))
3. Zendesk: Web API (Credential Type: Basic, No API Key: Json.Document(Web.Contents("https://support.ipnos.com/api/v2/tickets.json")))
4. Flurry: Web API (Credential Type: Anonymous, API Key and Header is needed: Json.Document(Web.Contents("https://api-metrics.flurry.com/public/v1/data/appUsage/day/app/country?metrics=activeDevices&dateTim..., [Headers=[Authorization="Bearer API KEY"]]))

I can refresh all my data in Power BI Desktop with no problem at all, however when I publish it on the web app and try to refresh the dataset I get this the Data source credentials section:

Also even if I edit all credentials, there are still 1 source that I can't edit, this is the one with the Header, here's the message once I try to edit credentials:

What can I do to make this work?

[cecyarmida]

As far as I know that is a current restriction on Power BI service, I just wrote a blog to bypass that issue:

https://blog.kloud.com.au/2018/07/23/use-anonymous-authentication-on-web-data-sources-with-a-api-key...

[Simont]

Any idea anyone?

[Anonymous]

I was having the same similar issue using API calls. This was working about a month ago but, for some reason I have a report that I cannot refresh anymore. Some other post in the community say change the permission to anonymous but, it doesn't do the trick for me.

You can find on github there are some examples of using the custom data connection use oaut2 and some other types of auth. I haven't spend the time to re-write my report in this same structure. Might be worth looking into these samples.

https://github.com/Microsoft/DataConnectors

Let me know if this helps!