excel - Unable to display all the table fields from XML in Report Builder

Question

I am having a hard time display all the table fields in Report Builder especially the table that had a NULL or empty record. I tested the XML file in Excel and it displayed all the tables

Here is the XML file and there are some fields that did not appear in the file. I think some of the fields are hidden so im not sure if that the case but again its working in Excel

And here some of the fields that display in Excel but not in Report Builder

Dataset for Report Builder

My question is how can I display all table fields from XML files in the Report Builder?

Answer 1

等待大神答复