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

Hi Anonymous ,

 

The get data from folder, has two different options.

 

  • Load
    • Returns the values has you have in a simple table with data
  • Combine & Transform
    • This option will ask you to select the file to use as model and creates a function were all the informatin is setup accordingly to your needs
      • Opens the XML table
      • Allow to add change columns

Further more on the combine and load you can see there is are several steps that allow to filter the columns before the files being combine.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi MFelix,

     

    Thank you very much for your insight. ğŸ˜…

     

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ,

       

      Is your issue solved now?If so,could you pls mark the reply as answered to close it?

       

      Much appreciated.

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!
      • VoltesDev's avatar
        VoltesDev
        Icon for Helper V rankHelper V
        6 years ago

        Hi Kelly,

         

        No, it is not.  I've probably not make my self clear in the message. but I don;t know where because I thought it is explain clearly.😅

         

        Thanks.