Is there a maximum number of tables or objects you can import from db2?

[Ohene]

Hi, i am extracting and transforming data from IBM db2 with Power BI Desktop. I realised that when i connect to my database, i do not get all tables in the DB. Also, there are a lot of views created in the DB, but i am unable to get any of them. Is this a limitation on the Power BI Desktop?

[v-chuncz-msft]

@Ohene,

You may specify SQL statement in the Advanced options.

[Ohene]

@@@ 

i dont know if you understand what i am trying to say so let me put it clearer. What i am saying is that i am trying to load tables from DB using "Get Data" from the ribbon on Power BI Desktop. Now when i connect to my db, the number of tables that load up reach a maximum of 10000. i am saying that i have more than 10000 of such tables in my DB and the limitation prevents me from loading the particular tables that i would want to work with. Find screenshot below. The moment the count of tables reached 10000, it stopped and the expansion of tables did not include my desired tables. I am very new to Power BI so let me

know if there is something i am not doing right or if this is actually a limitation of Power BI.

[v-chuncz-msft]

@Ohene,

There is already an idea, you may leave a comment and vote it up.