Auto-refresh with ODBC Connector

Hi benito-3481 

 

If your MongoDB data source is located on a local server, you need to configure and install a Power BI gateway for scheduled refreshes after publishing to Power BI Service.

 

Here are the steps to configure the gateway:
1. Install the Power BI gateway:
Download and install the Power BI gateway (standard mode) on your local server. download link 

2. Configure the gateway:
Open the installed gateway and log in to your Power BI account.
Configure the gateway and make sure its status is Online.

3. Add a data source to the gateway:
In the Power BI service, navigate to the Gateway settings.
Add a new data source, select the ODBC type, and enter the connection information for your MongoDB data source.

4. Configure the gateway connection for the dataset:
In the Power BI service, navigate to your dataset and click Settings.
In the Gateway Connections section, select the gateway you configured and make sure the data source is mapped correctly.

5. Set up a scheduled refresh:
In Dataset Settings, find the Scheduled Refresh section and set the refresh frequency.

 

Please refer to these links to configure gateway.

Power BI Gateway | Microsoft Power BI

Power BI gateway and Report Builder support for ODBC data sources - Power BI | Microsoft Learn

 

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