REST API Basic Auth and Custom header

[fleming507]

Im trying to query a REST api. It's a multi-tenanted system and uses a combination of Basic Auth and an additional "Tenant" header.

However,  when I set up the connnection I get the following:

Expression.Error: The 'Tenant' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Referer

Without this header, I cannot authenticate. Is there a way to force custom headers or bypass the expression validation?

[v-yuezhe-msft]

@fleming507,

Do you set authentication type as anonymous as mentioned by the error messsage? What is the error message if you remove the Tenant header? Could you please share the Power query code you use  in Advanced Editor of the query in Power BI Desktop?

Regards,
Lydia