Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get Data from folder for XML

Hi,   Need help as I got issue with Get Data from Folder feature. The file I'm using are XML. I'm not really understand how XML works, but if I open it in Notepad, there is 1st tag (before Items ta...
Tips and Tricks
  • VoltesDev's avatar
    VoltesDev
    6 years ago

    Hi MFelix,

     

    I'm afraid not, if using Combine & Load, then after it either Load or again choose Transform data, it will directly read my XML and give me the result without epand the 'table' inside the Item tag.

    Like this:

     

    So I think the best way still need to choose Transform at the very first. And this step also being tearched in every Power BI courses, they all saying to"not" use that, instead go to "Transform"

     

    Thanks

MFelix's avatar
MFelix
Super User
6 years ago

Hi VoltesDev ,

 

Did you tried to get the information based on the setup I have send out? 

 

Has refered when  you make the combine there a  couple of columns that are removed one of them is the date created and you can keep it in the list if you go to change the step where the column is removed.

 

Are you abble to send out a  sample of your files.

VoltesDev's avatar
VoltesDev
Helper V
6 years ago

Hi MFelix,

 

I found the problem, it looks like I missed one step after the 1st "Combine files"

After my screenshot :

There is another grid like this :

And I just click the Table link all this time, whilst not realized that it is actually resembled the XML Tag in my own file.

Just now I tried to cllick the small icon on the Items column header (is it heavy lifting icon ??)

and choose the "Use original column name as prefix" (need to do it twice, I supposed to make field refreshed), then it will show me all columns including the source name and my 1st XML tag before Items.

 

Aplogize, I should realized it sooner.

 

Many thanks for your help and patience.

 

regards,

 

 

 

 

 

 

 

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Glad you could figure it out.

     

    As I refered instead of the combine if you choose the combine & load that would simplify your life. Try to check it out.

     

    Please mark your answer as the correct one so it can help others.

    • VoltesDev's avatar
      VoltesDev
      Helper V
      6 years ago

      Hi MFelix,

       

      I'm afraid not, if using Combine & Load, then after it either Load or again choose Transform data, it will directly read my XML and give me the result without epand the 'table' inside the Item tag.

      Like this:

       

      So I think the best way still need to choose Transform at the very first. And this step also being tearched in every Power BI courses, they all saying to"not" use that, instead go to "Transform"

       

      Thanks