Forum Discussion

adrianVE278's avatar
adrianVE278
Frequent Visitor
3 years ago
Solved

Connect Power BI / data federation Mongo DB and MongoDB Atlas SQL connector beta)

I am trying to connect my power bi desktop to a Mongo DB federated database instance. I followed the previous steps for it, in summary: * I have a user in mongo atlas with readAnyDatabases permissi...
General Comment
Need Help
  • adrianVE278's avatar
    adrianVE278
    3 years ago

    The problem has been solved since I wrote, what happens is that the preview of the collection looks like the photo in the original post, however, when loading the data to transform it (or just loading it), it looks like the attached photo . But, it loads the subdocuments as objects literally as opposed to tables linked by _id as it does or to the MongoBI connector when it loads successfully.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi adrianVE278,

The data connector should design based on data source api to getting data. So these result fields may be different from the common table that you visited in the data source. (they may include some logic and flag field that be used in backend processing or other type of operations)

Regards,
Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Is there a way to transform this data in PowerBI to a table-like data rather an object? Getting the same issue loading from MongoDB via MongoDB Atlas connector