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
Icon for Super User rankSuper 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
Icon for Helper V rankHelper 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