Hey there since i m using couchbase capella and trying to connect it with power bi
i have followed all the official couchbase documentation given as below link 
still while connecting to power bi i m getting error as below
error msg :- Details: “ODBC: ERROR [08003] Connection not open
ERROR [08003] Connection not open”
below are details i filled in odbc driver configuration
can anyone help me with this please ?
Did you Allow IP of your client?
SDK Doctor can be used to give diagnostics regarding connectivity.
in the setting there is allowed IP address and i have allowed my current IP and all Common IP for now
is there anything else i should do regarding IP ??
and with sdk doctor i am not able to identify the issues still
Please post the output from sdk doctor
:
[WARN] No certificate authority file specified (–tls-ca), skipping server certificate verification for this run.
[WARN] The hostname specified in your connection string resolves both for SRV records, as well as A records. This is not suggested as later DNS configuration changes could cause the wrong servers to be contacted
[ERRO] Failed to fetch configuration via cccp from svc-d-node-008.x8hof-tzngozvc3.cloud.couchbase.com:11207 (error: invalid bucket name/password)
[ERRO] Failed to fetch configuration via cccp from svc-d-node-007.x8hof-tzngozvc3.cloud.couchbase.com:11207 (error: invalid bucket name/password)
[ERRO] Failed to fetch configuration via cccp from svc-d-node-006.x8hof-tzngozvc3.cloud.couchbase.com:11207 (error: invalid bucket name/password)
[ERRO] All endpoints specified by your connection string were unreachable, further cluster diagnostics are not possible
This is given by SDK doctor
and could you also tell me steps for creating Tabular analytics view in couchbase capella
because when i tried its is giving me error like no function exist like ‘create analytics view’
in query section of buckets
It says the bucket name and/or the username and/or the password you are using is incorrect .
What are you using for the SDK Doctor command?
below is the command i using and the username and password of cluster i created on capella
sdk-doctor-windows.exe diagnose couchbases://cb.-*****.cloud.couchbase.com/ -u Power_BI_connect -p @3 --tls-ca "C:\Users*\OneDrive\capella-root-cert.pem"
if there is another cmd i can use please do provide me
thanks
Apoend the bucket name to …couchbase.com/
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
