Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
Can anyone help me, how to combine multiple Json files which are in one folder in power query?
Thanks in advance.
Solved! Go to 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.
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
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.
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.
@Anonymous Use a Folder query?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
100 | |
76 | |
68 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |