Load multiple files at a time

Anonymous , Have you tried option load data from folder

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

Hi Anonymous 

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

regards

Phil

Hi Anonymous 

You shouldn't be modifying the Transform Sample File query.  If you need to add transformation steps do it in the main ev query.

The PBIX file I provided has working code that works when you add more files to the folder.

Initially the query was loading 2 JSON files.  The fist had 20 records

 

and the 2nd had just 1 record

 

Expanding those tables and then expanding the records inside the tables gives 24 rows of data

 

Now I added 3 more JSON files to the same directory - I just made copies of the files I had.  The file contents don't matter, this is just for demonstration.

Refreshing the query shows that it is now seeing 5 files - that is correct.

 

Expanding the tables/records gives 71 rows of data (you can't see them all in this screenshot)

 

So the query is working to pick up new JSON files correctly.  I don't know what you are doing and why you are having trouble.

If you just use my PBIX and alter the Source step to point to the directory you are using where the JSON files are, it should work

 

If you are still having issues please provide your PBIX file so I can check the code you are using.  And also provide some screenshots of the data with null values.  And provide copies of these new files that aren't working.

regards

Phil

Hi Anonymous 

The column names in that new JSON file don't match the other files, that's why you are getting a null row.

In the main ev query if you click on the Expanded Table Column1 step the main part of the window shows you 2 columns, the name of the JSON file (that the record comes from) and a column of Records

 

You can click in the column beside the Record to get a preview of the data in the record.  For the file Energy_EV_Meter_11 you can see the column headers are a mixture of upper and lower case

 

 

But for the new file Energy_EV_Meter_47 the column names are all upper case.

 

Power Query is case sensitive.  When the ev query was first created it saw column headers in mixed case.  The new file is all upper case column headers so when the ev query tries to Expand Columns in the last step, it can't find the column names it expects in the new file - and it just creteas null values

 

The ev query works correctly.

To fix this, the new JSON file must have column names that match all the other files.

Regards

Phil