Unable to connect: We could not register this data source for all gateway instances within this cluster.

db2 powerbi powerbi-datasource
Kannas Somasundar picture Kannas Somasundar · Jan 22, 2018 · Viewed 7.3k times · Source

I have developed some reports using power bi desktop which is using IBM DB2 as datasource. I have installed On-premises data gateway in my power bi system and configured. I have to create ibm db2 datasource connection in power bi web to make live connection with my IBM DB2 database. When i tried to create datasource connection it showing me unable to connect error message.I have given correct credentials but still it showing the same error. Am i missing anything? any special permissions needed to provide from IBM DB2 database admin side? Please help me to solve this issue.

Thanks in advance, Kannas

Answer

Rory picture Rory · Aug 30, 2018

I had an identical error. The issue appears to be related to the credentials given in the data source settings when configuring in the online service. In my case I had not entered the domain with the username.

Related questions

SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null

What does sqlcode -302 means? Where do i get the sqlcode definitions? Please advice Thanks,

Read More
How to view DB2 Table structure

How to view the table structure in DB2 database

Read More
DB2 Query to retrieve all table names for a given schema

I'm just looking for a simple query to select all the table names for a given schema. For example, our DB has over 100 tables and I need to find any table that contains the sub-string “CUR”. I can use the …

Read More