That's a good idea. I tested it on my computer. (Win11)
But do a backup before!
You need to install the ODBC drivers on your local computer.
where the locale db is, timo has postet.
You need this path for the connection.
open PowerBI and go to:
- get data
- select ODBC
- select SQLite 3 Datasource
- In advanced options, enter the path of the db "database = C: \ ....... \ data.db"
then you should see all tables in the new window.
as timo says, at your own risk!