Refresh error when getting data from a secure REST API

[AUaero]

Hi,

I've got a dataset that pulls data from the freshservice API.  My Power Query code passes the API key in the header (code below).

Source = Json.Document(
    Web.Contents(
        "https://xxxx.freshservice.com/", 
        [
            Query=
            [
                per_page="100", 
                page=Number.ToText(page)
            ],
            Headers=[Authorization="Basic xxxxxxxxxxxxxxxxxxxxxxxxx"],
            RelativePath = "api/v2/tickets"
        ]
    )
)

I've got the connection set up for anonymous authentication.  When I go refresh the dataset, I get the following error:  "Please make sure your data gateway (personal mode) is installed and configured properly"

Any ideas?  Connecting to a web API shouldn't require a gateway at all so why am I getting a gateway error?

Thanks!

[Anonymous]

Hi @AUaero,

AFAIK, normally cloudy Datasource not required to use the gateway to handle refresh. (you can also turn on the option to use gateway manage datasets who existed both cloudy and on-premise data source)

Does your report dataset contain other connection mode data sources or any advance operation across your query tables? (merge, combine, reference, custom functions...)

In addition, any specific feature or script that only person mode gateway supported include in your report datasets?

Regards,

Xiaoxin Sheng

[GilbertQ]

Hi there

I think it does because it find the Json.Document, and your Web.Contents is embedded and cannot be seen as the data source?