DataSource.Error in Power BI – MongoDB Collections Show No Visible Columns
I’m trying to connect MongoDB with Power BI using the BI Connector and ODBC Connector. Most tables are loading fine, but for a few collections or the collection which I have added later I get this error:
DataSource.Error: The table has no visible columns and cannot be queried,
Details:
sample
What’s strange is that if I use the same collection in another database, it loads without any issue. Has anyone faced this problem before or found a solution?
Posted Jan 30, 2026, 5:16 AM UTC
10