View My Drafts
Mustang develops many interfaces to P6 via P6 Web Services using .NET/C#. We considered developing a P6 connector for Power BI for resale. But after reviewing it, I decided that a connector is not really feasible because of the amount of P6 data that needs to be extracted and the numerous requests to retrieve the data. Therefore, I decided to develop an extraction software utility that builds a reporting DB for BI reporting – the utility is called P6ETL™. Once the P6 data is extracted from the P6 DB into the P6ETL™ DB, users can develop BI reports with any report development tool that can connect to a SQL Server DB. To learn more about P6ETL™, go to www.p6etl.com.
However – if you just want to connect to the P6 DB (either the native DB or the PX DB) with Power BI, check out this LinkedIn Group: https://www.linkedin.com/groups/13914226/ I created a couple videos in the group to demonstrate how to create Power BI reports for P6.