Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
bilbo004
New Member

Power BI desktop not showing all tables in DB2 data source

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 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.