Forum Discussion
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...
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.