Cannot refresh report data using on-prem data gateway

[mdanner]

We have a Power BI report that's been receiving data updates via a personal gateway connecting via ODBC to a Filemaker Server.

We installed an on-prem data gateway on the Filemaker Server host, then configured the gateway's data source to connect to the same Filemaker Server locally via ODBC using a system DSN on the server. Connection successful!

The problem arises when trying to use that data gateway and data connection to refresh the dataset for the report. The error reported is:

Not configured correctly. Data sources included in this dataset: ODBC{"connectionstring":"dsn=aerorock_fm"} Add to gateway.

The ODBC settings have already been configured in the gateway's data source settings, but the error occurs in the dataset.

Why are we getting this error, and what do we do to fix it?

[v-diye-msft · Accepted solution]

Hi @mdanner 

1. Please kindly make sure you're using the latest gateway version and log in by your owner account.

2. please check on your gateway settings to confirm you have enabled 'Allow user's cloud data sources to refresh through this gateway cluster' option, it should be enabled if you are work with mixed on-premise and online data source reports

3. https://community.powerbi.com/t5/Service/Gateway-error-Refresh-failed-due-to-gateway-configuration-i... 

[mdanner]

Thank you. Item 2 solved the problem. Thank you @v-diye-msft !

[amitchandak]

@mdanner , refer if these two can help

https://radacad.com/the-power-bi-gateway-all-you-need-to-know

https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial

[mdanner]

Thank you for your reply, @amitchandak