Refresh data in PowerBI Service (online) connected with MongoDB Atlas

Hello all,

We have an M10 tier with the BI connector enabled. We have also set up a DSN to connect PowerBI via ODBC. This is working fine and we have been able to read our documents and build a small dashboard.

The problem starts when we publish the dashboard to PowerBI Service (the online version). Here we can see the plots and figures but we cannot refresh the data. We are trying to configure the connection credentials but the sign-in screen never ends (maybe we just need to whitelist the PowerBI IP ranges, but they change over time, so I guess this can be also an issue):

In addition, we have found some documentation saying that MongoDB connections to PowerBI Service may need a gateway to work, but I found nothing related to MongoDB Atlas. So, how can we set up this connection in order to be able to schedule the data refresh in PowerBI Service?

Hi Salvador,
you need to install a On–premise gateway in a pc to connect your powerbi service to MongoAtlas.

Once you do this, go to Manage connections a Gateway in Powerbi Service and select your Gateway previously created. Then when you refresh your data in PBI Service, this will use the gateway to connect to Mongo Atlas through your local Mongo ODBC, just like when you refresh with Powerbi desktop in your computer

1 Like