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 Disappear