Problem with ODBC and PowerBI

ODBC/JDBC
1

Hello everyone,
Today I was trying to connect PowerBI with my analytics and I encountered an error. This is the error:
DataSource.Error: ODBC: ERROR [HY000] LCB_ERR_UNSUPPORTED_OPERATION (214): Unsupported operation
ERROR [HY000] LCB_ERR_UNSUPPORTED_OPERATION (214): Unsupported operation
Dettagli:
DataSourceKind=Couchbase
DataSourcePath={“dsn”:“Test1”}
OdbcErrors=[Table]
I write down here some informations:

  1. I followed the guide for the Powet BI Connector.
  2. The server is self managed so I took the certificates like the guide suggests.
  3. The server is a cluster of different nodes: 3 nodes have only data, 3 have only query and index and the last one has the analytics.
  4. I already created all the views and tables that i needed in the analytics section.
  5. If I use one of the nodes of the data i have no tables at all, but I get no errors.
  6. The version of the couchbase is 7.2.4 build 7070 Enterprise and the user that i provide has full admin role.

If someone want to help me, I can provide more informations.
Thanks for the suggestions in advance,
Andrea

2

Other incidents of the same message indicate that the issue is with the couchbase connection string. Can you please show what you are using?

https://issues.couchbase.com/issues/?jql=text%20~%20"LCB_ERR_UNSUPPORTED_OPERATION"

3

Hello mreiche, thx for the support. I will share below a template similar to our environment with different names and a screen of my odbc configuration:
as i mentioned before i have 7 nodes. Each node is called like this (0-2 data, 3-5 index/query and 7 for analytics):
test1-couch-0000.test1-couch.test1-couch.svc:1111;
test1-couch-0001.test1-couch.test1-couch.svc:1111;
test1-couch-0002.test1-couch.test1-couch.svc:1111;
test1-couch-0003.test1-couch.test1-couch.svc:1111;
test1-couch-0004.test1-couch.test1-couch.svc:1111;
test1-couch-0005.test1-couch.test1-couch.svc:1111;
test1-couch-0007.test1-couch.test1-couch.svc:1111;
I think these are the internal addresses while the externals are like this:
test1-couch-0007.test1-couch.test1.com
Since i wanted to use the analytics i’m currently using
test1-couch-0007.test1-couch.test1.com

image
image537×521 35.8 KB

Maybe this addresses arent those one that the ODBC wants. If you can tell me where i could find it in couchbase i will try them.

4

I’m confused about all the ports being 1111. SSL Data is 11207, SSL Query is 18093 etc.

Screenshot 2024-08-06 at 10.09.46 AM

Host needs to be one of the data nodes.

5

The ports are an example, ours are like 8091 for all the nodes. If i have more nodes with data which one should I put? And more importantly, i already tried with it and i got no tables at all of the ones that i created in analytics

6

What do you have now? I can’t tell as you’ve blacked it out.

7

Now I have a this host: “test1-couch-0007.test1-couch.test1.com” and this is the node of the analytics.
The nodes of the data are:
“test1-couch-0000.test1-couch.test1.com”
“test1-couch-0001.test1-couch.test1.com”
“test1-couch-0002.test1-couch.test1.com”.
As i mentioned before, i tried to put the “test1-couch-0000.test1-couch.test1.com” and it didnt give me any error, but i couldnt see any tables. And i’m sure that in the analytics i have more than 15 tables.

8

No errors is definitely the way to go. I hadn’t noticed that earlier.
I suspect that the Couchbase analytics collections are not in the scope provided in your DSN definition.

9

Ok, maybe thats the case. I paste below the situation of my server.
image
If I have, like in my case, more nodes with data, how can i provide all of them for the ODBC? And also how can I check where my analytics collections are?

10

Refer to the ODBC driver documentation.

I would expect multiple data nodes could be specified in a comma-separated list like in the Couchbase SDKs.

11

Well, I tried all the things that the documentation of Power BI provided me. But for my case it didnt say much.

I dont even know if it is supported.

12

Are you using Capella or a self-managed Couchbase Server?

13

i am using self managed server

14

Try a comma-separated list - like couchbases://host1,host2,host3
btw - just one is sufficient for testing. Listing multiple hosts is for the case where one of them is unreachable - it will get the configuration from one of the others.

1 Like
15

Wait a second, maybe i solved the problem. I put all the nodes with a comma like in the sdk, I also put the default collection with a _ and now i found them.

The other problem is that when i updated the odbc, PowerBI needed also to be restarted because it didnt update well.

Thanks again for the help and the support.

16

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.