Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

SQLite database with ODBC conection - Automatic/scheduled update

I have a local .sql database file that is connected to Power BI through the ODBC interface. The connection works fine and I am able to visualize the data in Power BI. However, when the database is up...
Dataflow
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,

 

Based on your description, it seems that you want to automatically refresh the data from the ODBC data source in powerbi desktop. But there is no way to configure automatic refresh in powerbi desktop, it can only do manual refresh to get the latest data queried based on the DNS configured for ODBC and the corresponding SQL statements executed against the ODBC driver.


If you want to configure an automatic refresh mechanism, you can do so by connecting to a local ODBC data source through a gateway in the powerbi service. For details, please refer to the following similar solution. 


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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