Append/ Combine Multiple Json Files

[Anonymous]

Hi Everyone,

Can anyone help me, how to combine multiple Json files which are in one folder in power query?

Thanks in advance.

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[Anonymous]

Thanks for your response.

Unfortunately, Its not solved. In my case ecah Json files having different data (few files having more data& few are having less).
I tried with sample data too, but its throwing error.

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Here's an official document about combine files, please see if you are taking the right steps.

Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous Use a Folder query?

[Anonymous]

Thanks for your reply Greg,

I am able to import all Json files into Power BI by connecting to the folder. But when I apply the dynamic appending/ combining files it is throwing error.

[raisurrahman]

Problem is when you click combiner button it invokes Record.ToTable(Source) funtions. Just change this function to Table.FromRecords(Source). Hope this solves your problem.