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 

When the query tries to combine the iles the error is generated in the Transform Sample File query

 

This is caused by the 2nd step in the query which tries to convert the Source step into a table.

 

So, select the Source step manually from the list of steps, then click on To Table to manually convert the list of records to a table.

It asks if you want to insert a step- say yes.  Then use the default settings to convert to table

 

 

You now have a proper table conversion but the step causing the error still exists.  Click on it and delete it.

 

 

and everything should work fine.

Regards

Phil

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PhilipTreacy as we are manually modifying the transform file, we can see data only for first file after extracting to columns, remaining files showing nulls. I have crosschecked the same by doing the same process for excel files which is working fine. but not sure why we are getting error in json file. Please help me on this.

Regards,
Sri