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...
Thank you for your answer. But I can see that this is the static way of Extracting the data from P6, Transforming the data in Excel, and Loading the data by connecting it to the Power BI.
But I don't have a single project, I have multiple Projects, I want to make this process more dynamic by connecting all the stored datasets to the single Power BI report.
I have created a Power BI report with multiple DAX measures, M queries of Custom columns and Calculated columns. I want all these things come into one place.
Is there a possibility to achieve this?