Power BI: DataSource.Error: The table has no visible columns and cannot be queried

MongoDB Atlas
, ,
8

This doesn’t seem to work any more. Getting:

MongoServerError[Unauthorized]: not authorized, correlationID = 17de8adfca216581fbf81911

So, my guess is the UI features were added and this isn’t supported anymore to avoid mistakes?

I went to the Data Federation page in Atlas and clicked on the “…” button in Connect/Configuration/…, then “Manage SQL Schemas” and “Generate all default schemas” and was able to get passed the DataSource.Error: The table has no visible columns and cannot be queried error.

But when I look at the data inside Excel, it’s pretty much a jumbled mess of collections with a lot of data missing. Do I have to hand stitch everything back together, or is there a way we can get collections as separate SQL tables?

Thanks!