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.
raisurrahman
Helper II
Helper IIProblem 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.