Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello,
I am new user to Power BI desktop but a long time DB2 DBA. When I try to get data from a IBM Db2 data source (DB2 LUW 11.5) , I get a list of all the schemas in the DB2 database and I can see SQL statement used by desktop in the trace files to get the list of the schemas. So, I know my connection info is correct and working.
But, when I click on the schema names, most the schema don't show the list of the tables or views. Only about 25% of the schemas show tables/view even though most of the schemas do have tables/views. The SQL call to DB2 for the table names doesn't show up in any trace file either.
This is not a permission issue as I have full access to the database and can query any DB2 table/view with the id I am using.
Any help would be greatly appreciated.
Regards,
Bill
@bilbo004 , Are there more than 10000 tables in the schema? Is there any specific type of table not shown? like having some character in table name etc
@amitchandak : There are not more than 1000 tables in the schemas and no specific tables names that aren't showing up. Even the DB2 system tables : SYSIBM tables (184) and SYSCAT views (154) are not showing up.
There are no special characters in the tables names .