Forum Discussion

gowrishankar65's avatar
gowrishankar65
Helper I
9 years ago

IBM DB2 - tables not loading

Hi ,    Problem Statement: I am using IBM DB2 as datasource in PBI desktop after giving server name and database name Navigator window is showing up in whihc I need to select the tables to load it ...
Need Help
gowrishankar65's avatar
gowrishankar65
Helper I
9 years ago
Anonymous, As you said, I had discussion with DB2 people and they told whenever connection is made to pull data from DB2 it firstly invokes the system stored procedures like SYSIBM.SQLCOLUMNS and SYSIBM.SQLSTATISTICS. So they made changes in their end and when I try it was working fine. I have another question here, I am trying to pull tables from particular schema which contains more than 30,000 tables in it but when I make connection in PBI desktop it just shows 10,000 tables and not more than that. Is there any limitations in showing the list of available tables in PBI desktop. Regards, Gowrishankar
tbastian's avatar
tbastian
Frequent Visitor
5 years ago

Hello Lydia <@v-yuezhe-msft>,

Thank you Gowrishankar for bringing up this issue. 

I am facing the same problem when conncting to DB2 from PowerBI.

All the tables and Views show up in the Navigator but the Alias Names do not. 

In some projects the DBA's set up Alias Names as the projects navigate through Dev/Test/Prod. 

The data can be accessed using Native Query .... under the Advanced Options.

I tested both the IBM driver as well as the Microsoft driver and the results are the same.

Alias Name objects are not displayed.  

 

Under SYSIBM/SQLTABLES , all these object names are displayed but none of the objects whose table type is ALIAS show up on the Navigator pane , uner their Schema name .

 

Is this a known issue ? or is there a work around other than Native Query ?

 

Please advice 

 

Thanks 

Thomas