HOW TO CONNECT PRIMEVERA XER FILES TO POWER BI

Question

I got a task to work with primevera xer files data, but i am unable to find any link how would we can connect to XER . Please suggest on this

edhans · Answer

According to this website, it is just a CSV file that uses a tab as the delimiter.
So just use the Text/CSV connector. In the lower right, change it from .txt, .csv, .prn to ALL FILES.&nbsp;

Then change the delimiter on the first screen to a TAB.

&nbsp;
&nbsp;

mjalari · Answer

this process is not working for me

edhans · Answer

Well&nbsp;MJALARI&nbsp;you are going to have to give us some more info. Error messages, screen shots, sample files, something. "It isn't working" doesn't give us anything to go on here.
&nbsp;
How to get good help fast. Help us help you.How To Ask A Technical Question If you Really Want An AnswerHow to Get Your Question Answered Quickly - Give us a good and concise explanationHow to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

v-jingzhang · Answer

Hi&nbsp;MJALARI&nbsp;
&nbsp;
Which error or problem do you meet when using the&nbsp;Text/CSV connector? I tested with this connector to connect to a sample XER file and got the data in Power Query Editor successfully. Were you able to see the data in Power Query Editor? Maybe you could see the data but would need to do some transformations to make data look more organized to be analyzed?
&nbsp;
Regards, Community Support Team _ Jing