Issue with Dataset with Incremental Refresh Web.Content on Gateway

[Centurius_de]

Dear all, 

i was building a successful query for web content using power bi desktop, once all was set I pushed it to our on premise gateway, when I hit refresh I get an error which does not happen locally

let
strRangeStart = DateTime.ToText(RangeStart,[Format="yyyy-MM-dd'T'HH'Z'", Culture="en-US"]),
strRangeEnd = DateTime.ToText(RangeEnd,[Format="yyyy-MM-dd'T'HH'Z'", Culture="en-US"]),
Query1 = Json.Document(Web.Contents("http://xxxxx.xxxx", [Timeout=#duration(0,5,0,0),RelativePath="v2", Headers=[#"Authorization"="foo",#"Content-Type"="application/json"],
Content=Text.ToBinary(
"{
""queryType"": ""groupBy"",
""dataSource"": ""bids"",
""intervals"": """& strRangeStart & "/" & strRangeEnd & """,
""granularity"": ""month"",
""dimensions"": [""organization"",""os"",""account_manager"",{
""type"": ""extraction"",
""dimension"": ""campaign"",
""outputName"": ""campaign_type"",
""extractionFn"": {
""type"": ""registeredLookup"",
""lookup"": ""campaign_type""
}},
{
""type"": ""extraction"",
""dimension"": ""ad"",
""outputName"": ""content_type"",
""extractionFn"": {
""type"": ""cascade"",
""extractionFns"": [
{
""type"": ""registeredLookup"",
""lookup"": ""content_type""
},
{
""type"": ""registeredLookup"",
""lookup"": ""content_type_display_value""
}
]
}}
],
""filter"": {
""type"": ""in"",
""dimension"": ""event_type"",
""values"": [""bid"", ""click"", ""win"", ""buying_conversion""]
},
""aggregations"": [
{
""name"": ""bids"",
""type"": ""longSum"",
""fieldName"": ""bids""
},{
""name"": ""wins"",
""type"": ""longSum"",
""fieldName"": ""wins""
},
{
""name"": ""clicks"",
""type"": ""longSum"",
""fieldName"": ""clicks""
},{
""name"": ""impressions"",
""type"": ""longSum"",
""fieldName"": ""impressions""
},
{
""name"": ""supply cost"",
""type"": ""longSum"",
""fieldName"": ""win_price_eur""
},
{
""name"": ""revenue"",
""type"": ""longSum"",
""fieldName"": ""buying_price_eur""
},
{
""name"": ""spend rate"",
""type"": ""doubleSum"",
""fieldName"": ""spend_rate""
},
{
""name"": ""ap_conversions"",
""type"": ""longSum"",
""fieldName"": ""ap_conversions""
},
{
""name"": ""ap_customer_revenue_eur"",
""type"": ""longSum"",
""fieldName"": ""ap_customer_revenue_eur""
}
]
}"
)]
)),
totable = Table.FromList(Query1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
expand = Table.ExpandRecordColumn(totable, "Column1", {"timestamp","event"}, {"date","Column1.event"}),
custom = Table.ExpandRecordColumn(expand, "Column1.event", {"organization", "account_manager","os","campaign_type","content_type", "bids","wins","impressions","clicks","supply cost","revenue","spend rate","ap_conversions","ap_customer_revenue_eur"},{"organization","account manager", "os","campaign type","content type","bids","wins","impressions","clicks","supply cost","revenue","spend rate","ap_conversions","ap_customer_revenue_eur"})
in
custom

When I use a dataflow all works, but since we use incremental update and the workspace cannot be premium I need to stick with a dataset. 

We use an on premise gateway:

I uses ananoumus authentication 

But I have no clue what that error means? 

the logs says something like: 

M.EnterpriseGateway Error: 0 : 2023-02-22T20:20:33.8391400Z DM.EnterpriseGateway	cbd63194-1766-4939-895b-b8f46ef0be60	779be232-a0ee-47a8-91cc-35b32ff3a7ec	MGTD	062a95cf-3e0d-4157-9457-ec85a3af5fc1	fa96f4a9-d6e4-406e-a5c1-6b911e7727c4	fa96f4a9-d6e4-406e-a5c1-6b911e7727c4	CC89564C [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <ccon>[ccon]Web.Contents failed to get contents from 'http://xxxxx.xxxx' (405): Method Not Allowed[/ccon]</ccon>