Hello, please suggest any variants where have I made a mistake...
I have some ERM database in xml. Some tables are aailable without identification (local network).
Others - need Bearer token
I'm connecting from Power Query to "open" tables:
= Xml.Tables(Web.Contents("http://192..../GetShippedPaidReport2?beg_date=2024-04-01&end_date=2024-05-15"))
And have needed data.
But when I try to use token, I have a problem:
=Xml.Tables(Web.Contents("http://195..../GetWarehouses", [Headers = [Authorisation = "Bearer ey...DMmwfI"]]))
Error (translated):
"Expression.Error: The "Authorization" header is only supported when connecting anonymously. These headers can be used in all types of authentication. Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer"
When I try to change the Data Source Settings to Anonymous it still doesn't work.
I'm not an IT person, and the IT dept can't help. It seems the request is correct. But obviously I'm doing everything wrong.
Please give some advice.
