Power BI desktop not showing all tables in DB2 data source

[bilbo004]

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 

[amitchandak]

@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

[bilbo004]

@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 .