Forum Discussion
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...
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
Anonymous , Have you tried option load data from folder
https://insightsoftware.com/blog/power-bi-load-data-from-folder/
amitchandak I'm having json files, it is not allowing me to combinne and load them. gettinng error
https://www.dropbox.com/s/f4otjr9y2y2zt43/LoadError.PNG?dl=0