Exporting Activity Usage Spreadsheet & Resource Assignment with .XER to Power BI

[Anonymous]

Hi, 

I am importing .xer files to PowerBi. The data imported from .Xer does not contain Activity Usage Spreasheet or the Resource Assignment. 

Any idea how to export these with the .xer.

[v-chenwuz-msft]

Hi @Anonymous ,

Currently power bi does not have a direct connection to the .xer file connector, you can try to connect it after converting it to excel. If you are familiar with the compilation rules of .xer files, you can try to connect directly with

File.Contents.

This video you can refer.

Open XER Files in Excel - YouTube

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you for the reply. I can actually load my .xer file to power bi but the information exported is not enough such as activitybusage spreadsheet and the Resource aassignments. I am not sire if there is a way to customize the export in Primaver P6