Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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.

Need Help
Show and Tell
Tips and Tricks

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        raisurrahman
        Helper II
        11 months ago

        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.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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.