Forum Discussion
MongoDB data tables disappear.
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
5 Replies
how many tables do you have in that database?
53 tables
currently appear 53 tables and other disappeared tables 5 so total 58 tables
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 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?
