just a proof of concept how to Connect PowerBI to Primavera's SQL Server Backend, the report show how to dynamically select columns in a Matrix Visuals

for XER and SQLite please check this PowerBI file, which is more developped

https://github.com/djouallah/Xer-Reader-PowerBI