Limit Number of Tables in Import List from Oracle Database?

[rodneyc8063_1]

So I have a few questions I was hoping for some help on please

I have an end user connecting to a database, and he is unable to find his tables. I tried to recreate his issue and found the following

So when I connect via PBI to his schema I see the following

I saw that the number of tables counted up to 10000 and then stopped.

I tried to input the table I was looking for into the "Search" bar and it did not show up.

So I am "assuming" that PBI has a limit of being able to pull in a list of 10000 tables - Fair enough

I am also assuming that the "Search" bar will ONLY search within this generated list of 10000 tables, therefore I wasnt able to find the table I was looking for.

But when I "Get Data" and on the Oracle Database screen, I choose -> Advanced Options and input a SQL statement I am able to pull in the table data

So a bit tedious, but I am able to "Get Data" a few times and can pull in the tables using the advanced options with SQL.

So I have two questions, for curiosity sake

1) Is there a way to "filter" tables before even importing and creating a list? For example, if I wanted to find ALL tables with the prefix of XYZ_ - Or is it only a SQL statement that I can do?

2) Not sure if anyone would know, but I also noticed that PBI was picking up all these BIN$ tables - Whereas when I log in via SQL developer I ONLY see the relevant tables. So how does PBI actually generate its list of tables? As I actually can not see where all these BIN$ tables came from?

Any insight much appreciated

[Greg_Deckler · Accepted solution]

Pretty sure you are going to be stuck using the SQL method. No idea where the BIN tables are coming from.

[rodneyc8063_1]

@Greg_Deckler Thanks for confirming my understanding.

I spoke to our DBA's and apparently the BIN$ tables are all tables from the "Recycle Bin" of our Oracle database. 

So looks like PBI some how queried the recycling bin as well for all the tables

We purged the recycle bin and now the BIN$ tables are all gone.