cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ohene Frequent Visitor
Frequent Visitor

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

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?

3 REPLIES 3
Community Support Team
Community Support Team

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

@Ohene,

 

You may specify SQL statement in the Advanced options.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ohene Frequent Visitor
Frequent Visitor

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

 

@@@ 

 

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.

 

bi forum.PNG

 

Community Support Team
Community Support Team

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

@Ohene,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)