ODBC architecture mismatch when refreshing data

Hi KellyZhou444 

GilbertQ Good share!

Considering that you can only use a 32-bit ODBC connection with Power BI Desktop, try the following solutions:

Make sure that the on-premises data gateway used to refresh data in the Power BI service is also a 32-bit version to match the 32-bit ODBC driver and Power BI Desktop.

You need to install the 32-bit Data Gateway if it is not installed. If you installed the 64-bit version, you will need to replace it with the 32-bit version.

After installing the correct version of the data gateway, configure the data source to use the 32-bit ODBC driver.

Go to the "Manage Gateway" section in the Power BI service and set up the data source with the correct credentials and connection details.

Test the connection and make sure the data source is configured correctly in the local data gateway. This can be done through the data gateway settings in the Power BI service.

Once the data source is configured correctly, try refreshing the dataset again in the Power BI service.

If the refresh fails, check for specific error messages. If the problem persists, viewing the logs in the local data gateway may provide additional information.

Regards,

Nono Chen

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