Data source is ODBC. I want to schedule refresh from Power BI Service.

[Periksson]

Data source is ODBC. I want to schedule refresh from Power BI Service.
Do I have to refresh the source in Power BI Desktop first so it can be refreshed

in Power BI Service or is it automatically refreshed without Desktop?

[v-frfei-msft · Accepted solution]

Hi @Periksson ,

You can use gateway to set schedule refresh. In this case, you can input the connection string following the steps below.

1. Check your DSN name(testodbc1 in my scenario) in ODBC administrator or in Power BI Desktop if you have connected to the odbc data source from Power BI desktop.

2. Add data source under gateway by entering connection string , account and password as shown in the following screenshot .

3. Schedule refresh for the dataset in Service.

In addition, please ensure that you create a system dsn in ODBC administrator .