Forum Discussion
ETL process for XER data
Hi adarshthouti
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No, the solutions provided by users are manual, but I am seeking an automatic solution, such as a completely dynamic approach as mentioned in my previous replies.
Currently, I have created a parameter in Power BI to select the path where the XER files containing the project data are stored in Power Query. It then transforms the data based on the transformations made in Power Query.
I have also created multiple measures, calculated columns, and calculated tables in Power BI Desktop.
My objective is to make this entire process dynamic, allowing for the comparison of two or more projects. I have set up a dropdown box to select projects and compare them.
Therefore, I need a solution on how to achieve this dynamically, without manually copying data from Primavera into Excel and connecting it with Power BI Desktop.
One of the solution which I have known from an ETL expert is parsing the XER files using Python and storing all those in a data warehouse or database and creating the calculations in it and finally connecting it to the Power BI.
are there any alternative approaches to achieve it?