Showing results for 
Search instead for 
Did you mean: 

MongoDB ODBC database disappear frequently

Hi everyone!

I have created PBI dashboard using MongoDB using BI-connector in ODBC and i'm facing a big problem to load a specific tables..

I have more than 60 tables in this database and some tables i frequently disappear and then appear. When i'm trying to load to PBI query some time load successfully and a lot of time receive loading error due to database is suddenly disappear.. When i disccussed the database developer he mentioned that these tables is related to some transactions and can't be fix to be all the time appearing

Is there anyway to solve this problem and make these tables stable and not disappear or any other solution like creating advanced query or create new table in the PBI with the same structure so it can be loaded once the database appear and if these tables disappeared give me same table even with blank values but not disappear so i can create the relations and measures

Below some photos for the databse in both conditions Appear and DisappearScreenshot 2023-06-10 002056.jpgScreenshot 2023-06-10 002221.jpg


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors