Connecting Oracle Primavera P6 which is in Azure Cloud to Power BI

Hi Anonymous ,

Please make sure you have read access to Primavera P6 Database.

If the DBA doesn't want to give you the read access, you need to open the XER file with Excel (or Notepad), then connect that file to Power BI. 

Please click on the below links and read them.

Understanding Primavera XER Files 

P6 XER file using the XER File Parser 

Or you can try to connect to this database by REST API.

For reference: Using a REST API as a data source

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.