Schdule Refresh

[govind_021]

Hi Everyone , I am importing data from MongoDB atlas in Power Bi and In power bi service I am unable to do a schedule refresh
please have a look , getting this message

Help regrading this is greatly appreciated. Please help

[v-rzhou-msft · Accepted solution]

Hi @govind_021 ,

Please make sure that you have installed the On-Premise Gateway.
And you need to make sure MongoDB Connector and ODBC Driver Installed in local. 

For more details, you may refer to below post with similar issue like yours.

PowerBI MongoDB Atlas SQL Schedule Refresh - Working with Data / Connectors & Integrations - MongoDB...

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sergii24]

Hi @govind_021, may I ask you why do you decide to go with "Direct Query"? This connection type often is limited on types of transformations you can perform in PowerQuery. Try to do the following:

1. Stay with DirectQuery mode and remove any complex transformations of you data (keep simple select columns, filter rows by static values but nothing more). Publish such semantic model and verify whether the issue persist
2. If not, then the error is likely to be caused by transformation: go to import mode with all transformations you need. Publish semantic model and verify if it works. If everything is okay, then you'll need to decide whether you need DirectQuery or complex transformations but then using import.

Good luck with your project!