Forum Discussion
ETL process for XER data
How to extract multiple XER datasets from multiple projects and store it in a database and connect that database to Power BI. For example I have some projects like Project A, Project B and Proj...
It is possible if you can find an automated way to dump files in a Sharepoint folder (One Drive for Business) from P6. This will require some planning on your end how to store project specific files in a seperate folder then connect your Power Query with dynamic parmaters to select a specific folder.