Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Load multiple files at a time

Hi Experts, I have multiple json files in the folder with same structure. I want to load all the files at a time and create the visualisation. If new files are added to the folder, it should refre...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    This is odd, I can't figure out the reason for the error.  I've checked your JSON files and they are valid JSON so I don't know why PQ is generating an error.

    I fixed the problem by manuallay editing the Transform Sample File query and it now works.

     

    Please download this PBIX file and test it with your files.

     

    You will need to edit the Source step of the ev query sothat it points to your directory where you have your files. 

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

Please supply some sample JSON files,impossible to debug without seeing what you are loading.

regards

Phil

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PhilipTreacy  attached are the files
https://www.dropbox.com/sh/zxy3ti8umls94my/AABSQf-4qZNuY9FIyjrA7c6ma?dl=0
i can load all the files at a time, it will load in binary format, here i'm converting all the files individually to table which is not going to work if we have more number of files. So i'm looking for doing the process one time for all the files even we have files added later