Forum Discussion
Append/ Combine Multiple Json Files
Hi Everyone, Can anyone help me, how to combine multiple Json files which are in one folder in power query? Thanks in advance.
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.