Anonymous Web Source asking for credentials

[CastroRibeiro]

I have two databases that are updated via getaway, normally, only this API that has an authentication problem, even though the API does not need authentication.

In powerbi desktop I can update normally, when I upload to the service it starts to give the problem

My code:

let
    Source = Json.Document(Web.Contents("https://ceo.xyz.com.br/api/programacao/painel_todos.php")),
    #"Converted to Table" = Table.FromRecords({Source}),
    #"Expanded data" = Table.ExpandListColumn(#"Converted to Table", "data"),
    #"Expanded data1" = Table.ExpandRecordColumn(#"Expanded data", "data", {"unidade", "rebocador", "data_inicio", "data_fim", "observacao", "setor", "tarefa"}, {"unidade", "rebocador", "data_inicio", "data_fim", "observacao", "setor", "tarefa"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded data1",{{"data_inicio", type datetime}, {"data_fim", type datetime}})
in
    #"Changed Type"

[GilbertQ]

Hi @CastroRibeiro 

It appears that it cannot connect to the website from your gateway server. What happens if you log into the Gateway server and try and connect to the website from there?

Possibly something needs to be configured from your gateway server?