How to add Json.Document(Web.Contents) Source to Gateway

[PoweredOut]

Hello

I have taken a report over from a predecessor and would like to set up one of the sources as a source on the Gateway. I am having issues doing this. 

It's a Web connection with an Anonymous credentials.

Below is the first line of the Query

Json.Document(Web.Contents("https://VARIOUSLETTERS.execute-api.eu-west-1.amazonaws.com/lineItems",[Query=[hapikey="API-KEY_HERE"]]))

I have tried various URL formats when trying to add the URL in the Web Connector on the Gateway

• https://VARIOUSLETTERS.execute-api.eu-west-1.amazonaws.com/lineItem/hapikey=API-KEY_HERE
• https://VARIOUSLETTERS.execute-api.eu-west-1.amazonaws.com/lineItem/API-KEY_HERE
• https://VARIOUSLETTERS.execute-api.eu-west-1.amazonaws.com/lineItem/apikey=API-KEY_HERE

Any Ideas?

Thanking in advance

[v-zhangti]

Hi, @PoweredOut 

Please refer to the following links in the hopes of helping you.

Solved: Gateway for Web data source? - Microsoft Power BI Community

Solved: Is a gateway required for online refresh of web co... - Microsoft Power BI Community

Solved: Can't add web sources to gateway cluster - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PoweredOut]

Thanks for your suggestions but unfortunately these don't help.

[PoweredOut · Accepted solution]

I have managed to add this source in the Gateway. I have adapted the URL to below 

https://VARIOUSLETTERS.execute-api.eu-west-1.amazonaws.com/lineItems?hapikey=API-KEY_HERE