PowerBI reads XML file incorrectly

[MarcusR1]

This is really strange, I have an XML file that PowerBI reads in without any problem, but it is skipping data! Here's a shot of the file in a text editor:

But in PowerBI the client_id, project_id and task_id are blank 

Has anyone else come across this? The XML file loads into other programs (excel) no problem (client_id arrowed)

I have tried refreshing the data, and even deleting the entire table and starting again, but nothing works!

plesae help!

OK, quick update - this is getting surreal!

I tried a few things (changed client_id to client_idnew) to check that PBI was actually reading the field, it put it at the end of the columns so I could tell it had seen something different. So then I went into the text editor and manually added 'blabla' to the record below the one I'm interested in:

and refreshed the Data Source in Power Query Editor, whilst watching the client_idnew column, expecting to see 'blabla' come into the column, and blow me down, the correct client_idnew for both records now read in correctly!!

It's almost as if the data was cached somehow, and that re-saving the file in the text editor (notepad++) corrected the XML somehow - this is so wierd! I still can't get the whole file to load the _id columns.

[lbendlin]

Try Table.Buffer to see if that forces a re-read.