How do I link to the data schema for Project in Microsoft 365 Project for the Web (P4W)?

[Anonymous]

How do we connect to the P4W data schema in M365?

I am NOT referring to Project Online (PWA) nor the Accelerator dataverse feed, which is a Dynamics 365 Power App.

Thank you!

[Sahir_Maharaj]

Hello @Anonymous,

Connecting to the P4W (Practice Management for Windows) data schema in M365 involves establishing a connection to the underlying database where the P4W data is stored.

1. Determine the type of database system used by P4W, such as Microsoft SQL Server, MySQL, or Oracle.
2. Obtain the necessary connection details for the P4W database, including the server name or IP address, port number, database name, and authentication method (e.g., username and password).
3. In Power BI, click on the "Get Data" button in the Home tab. Select the appropriate database source based on the type of database system used by P4W (e.g., SQL Server, MySQL, Oracle).
4. Enter the required connection details for the P4W database, including the server name or IP address, port number, database name, and authentication method.

After establishing the database connection, Power BI will display a navigator window showing tables and views available in the P4W database.

Should you require further details or assistance please do not hesitate to reach out to me.