I have played around with this.
It seems pretty easy to use SQLite with PowerBI, or MSAccess (as well as Dynamo)
The SQLite database can easily replace the tables in MSAccess and then this data used as a linked table in Access. Similar approach for PowerBI or any other application (Excel etc etc)
Correction to the above- SQLite can contain views (aka queries)
In the below example, I write (room data) out to an external database using Dynamo- then use this data in PowerBI or Access. I have used a simple insert query- which is why I have to delete the data before Dynamo runs so it is not doubled up, but it would be easy to change this to an update/replace query
