if you have a standalone installation of Primavera using SQLite, and you want to see the data stored there, either for reporting or just by curiosity to study the schema, it is pretty easy to do that using Powerquery.
unfortunately there is no native connectors to SQLite but you can use ODBC, please fellow this tutorial how to download and install the drivers ( sorry you need admin right, that’s why you should be always nice with the IT).
we don’t use standalone installation at work, I just download one installation from Oracle site in my home computer, the installation is valid for 1 month, once it is installed i copied the SQLite file generated by Primavera with all the template Projects.
the connection string is like this
Source = Odbc.DataSource(“driver={SQLite3 ODBC Driver};database=C:\sqlite\PPMDBSQLite.db;longnames=0;timeout=1000;notxn=0;dsn=SQLite Datasource”, [HierarchicalNavigation=true])
use the same password and username used for installation
don’t query directly the file, but use a copy, there is a risk that you corrupt your file.
keep in mind the tables in Primavera are highly normalized, and the spread data are not stored ( for example forecast labor units per day/task), so depending on your reporting requirements it can be a non trivial task.
anyway My PowerBI template now use either xer or sqlite to generate reports.
Small Data And self service 
Hi, I would like to get a step by step instruction guide to better implement this connection between P6 and Power BI. Please write to me if you can help me detailed instructions on connecting SQLite standalone database to power bi and then extracting the information.
LikeLike