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.

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper 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.