MongoDB data tables disappear.

[KareemMostafa12]

Hi all 🙂! i face a big issue while connecting MongoDB to PBI and trying to load a specific tables...

when i click Get data and select ODBC and browse database tables i found some tables some times appear and then disappear and this tables is very important.. almost of this tables is a Null values and when i try to connect it gives an error message as the selected tables doesn't include tables then tables disappear and after many refreshes the table and columns appear again but i can't catch them as fastly disappear.... I need help how can i fix thes tables column even they have a Null values i just want to make my queries and make the tables relationship then it will automatically updated if any value updated in the dataabase

[KareemMostafa13]

@lbendlin the problem is these tables sometimes appear and sometimes disappears so i can't catch them to load and start my query.. Do you have any solution to make it not disappear?

[KareemMostafa12]

currently appear 53 tables and other disappeared tables 5 so total 58 tables

[lbendlin]

I know there are limits in how many items a connector can enumerate. For example the Salesforce Reports connector can only show the first 10000 reports in a tenant which is ridiculous - we have many more than that.  But 53 seems very low for a limit.

[lbendlin]

how many tables do you have in that database?

[KareemMostafa12]

53 tables