Forum Discussion
Connect to web api authentication
Hello Everybody,
im trying to connect to the ixon api.
This works:
So when i try to authenticate via the build in power bi basci auth the querry will be:
In the Data Source Options I have set my EmailAdress and the Password in the Basic Authetification.
The Api doc is telling me:
The format of the basic authentication is “Basic authenticationstring”. The
authenticationstring is formed by encoding the string “email:one time
password:password” with base-64. The “one time password“ is only required when
Two-factor authentication is enabled and is otherwise empty.
I am leaving the one time password empty so i just added ":" after my email. Somehow it wont connect now.
This is the error im getting:
Expression.Error: The 'IXapi-Version' 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, Range, Referer
What am I doing wrong?
Thank you.
Regards, Luis
1 Reply
- ImkeFCommunity Champion
Hi Anonymous
basic authentication isn't natively supported for Web.Contents. But there seems to be a workaround (see here: https://social.technet.microsoft.com/Forums/office/en-US/11d4347c-0332-4dea-b270-a2dcd911c8b0/passing-username-and-password-in-basic-authentication?forum=powerquery) although I've never tried it.