Forum Discussion

MarcusR1's avatar
MarcusR1
Helper II
5 years ago

PowerBI reads XML file incorrectly

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.

 

 

 

 

 

1 Reply