Howto add a custom header to an odata connection

[Anonymous]

Hi, 

I'm requesting data from an odata service.

I would like to add the authorisation header manually to the advanced editor.

I'm using basic auth.

How can that be done?

This is my code:

let
Kilde = OData.Feed("https://odata.uniconta.com/odata", null, [Implementation="2.0"]),
DebtorInvoiceLines_table = Kilde{[Name="DebtorInvoiceLines",Signature="table"]}[Data],

FilterLogic =
if
FilterRows <= 0
then
DebtorInvoiceLines_table
else
Table.FirstN(
DebtorInvoiceLines_table,
FilterRows
),
#"Fjernede kolonner" = Table.RemoveColumns(FilterLogic,{"Cartons", "Weight"}),
#"Filtrerede rækker" = Table.SelectRows(#"Fjernede kolonner", each [Date] >= #datetime(2020, 1, 1, 0, 0, 0))
in
#"Filtrerede rækker"

[v-easonf-msft]

Hi,  @Anonymous 

Please check if these related thread could help:

authenticating with Excel Power Query against .Net Odata Web Api 

Power BI Query - post api request for authenticating and then make api calls 

Best Regards,
Community Support Team _ Eason

[lbendlin]

You can put it into the options parameter.

OData.Feed - PowerQuery M | Microsoft Docs