Forum Discussion

gowrishankar65's avatar
gowrishankar65
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper 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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

gowrishankar65,

Do you have sufficient permission on the other tables? Could you please write a specific SQL statement to get data from one of the 20000 tables during connection and check if it is successful?



Regards,
Lydia

  • gowrishankar65's avatar
    gowrishankar65
    Icon for Helper I rankHelper I
    9 years ago
    Hi v-yuezhe-msft, Yes, I checked that by giving SQL statement and I was able to retrieve data for those tables which are not showing in the navigator and I am going with this approach for my work. Will the system resources come into play for displaying all the contents in the navigator ?
    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      gowrishankar65,

      It should be a issue inside Power BI Desktop. Does it display all the tables when you connect to the IBM DB2 database from Power Query or Power Pivot?

      Thanks,
      Lydia Zhang