05.1-Automate Power BI and Excel Reports by using PRIMAVERA XER file and Power Query - XER reader

Are you spending hours copying and pasting primavera data into excel to manipulate the data for Power Bi reports and dashboards? This video shows you how to automate the entire process by unlocking XER Primavera file data with power query and no third-party tools needed. This video is for reading and exploring XER file only, which is the easiest part of the overall process. About XER Import/Export Data Map Guide (Project): https://docs.oracle.com/cd/F51303_01/... Chapters: 00:00 Introduction. 00:28 Preparation before Linking to XER File. 01:44 Linking Manually for explaining only. 06:21 Creating XER Power Query Table to XER file which contains all the data. 09:49 Creating Task Table which contains Activities ID, Descriptions, Dates. 11:37 Power BI sample report and changing the link to new XER file. 13:03 Excel Sample 13:40 What's next Enjoy Automation