I tried to follow the steps described by CB engineer here to see whether we can use PowerBI as our initial tool for reporting and BI.
The post describes the structure of the REST API URL, but it fails to explain how the integration can be done if the bucket / server require authentication.
I tried using this post with multiple options for user:password combination, such as:
local:server_user:server_password (i.e. local:Admin:xxxxx)
server_user:server_password (i.e. Admin:xxxxx)
server_user:bucket_password (i.e. Admin:yyyyy)
For all 3 options PowerBI fails connecting, reporting the following errror:
Authorization Failed Keyspace BUCKET_NAME
Can someone please explain me how to properly connect to the N1QL Query REST API with authentication credentials (either on request or HTTP Headers level)???
Thank you in advance,