Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started


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


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors