Failed to save modifications to the server. error returned: The x column doesnt exist in the rowset

[AlisaChen]

Hi Support,

When I try to use PowerBI desktop to get data from Mongo atlas, It's always return below error message,

The "_id" column exist in my mongodb, I don't understand what's mean of 'The _id column does not exist in the rowset'?

In additional, the data loading is too slow, which almost takes 30mins, it can be accepted. 

Can you provide some solution for my problem?

Thanks,

Alisa

[vpatel55]

I had this issue, and the following solution helped, but it took a little work to apply it to my model:

https://community.powerbi.com/t5/Service/The-column-does-not-exist-in-the-rowset/td-p/327629