Forum Discussion
Load multiple files at a time
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
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 what have you done in the pbix file exactly. i could not able to figure out the changes you made. Can you help me on this.
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
PhilipTreacy If I'm doing like this manually, after adding few steps like datatype change and splitting up columns.Next day any new files were added to the folder, the new file data showing null even though we are having data in that files when we refresh the pbix file.
Regards,
SrivalliPhilipTreacy 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