Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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 .
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 .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.