SQLite database with ODBC conection - Automatic/scheduled update

[Anonymous]

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 updated with new data, the ODBC connection doesn't seem to update the data in Power BI. The data is updated only if I open/explore the database in DB Browser (SQLite) and then refresh the data manually in Power BI Desktop. 

Is there a way to make this process automatic? I.e. when data is inserted into the database, it also updates in Power BI? 

This is the DSN configuration in ODBC:

[Anonymous]

Thanks for your answer, @v-henryk-mstf . A limitation of using a setup like this is that the gateway software has to be running on a computer for this to work, right? I was hoping to find a solution that doesn't rely on a running computer.

Eitherway, I tried to implement this solution, but now facing an issue of

"The credentials provided for the Odbc source are invalid. (Source at dsn=***)"

when setting up scheduled refreshes of the dataset. I am pretty sure that the credentials are correct, but what credential exactly is it referring to here? I don't have any credentials set up on the ODBC side, or on the .SQL dataset as far as I remember. 

[v-henryk-mstf]

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.