admin管理员组

文章数量:1353658

I have multiple(a lot) json files. One file basically represents one record. My goal is to feed the data to power bi, to do some analysis. I tried adding data to relational database MS SQL. But mapping got too complicated, because of lots of nested nodes. Then I simply merged few files to one json and feed to power bi. which seems to work. I get the data I want. Now my question is, what would be alternative to merging all those json files as size of the resulting json file would be a problem with increasing records. MongoDb may be simpler in this case instead MS sql, but I don't have option to use MongoDB.

本文标签: Json data handling for analysisStack Overflow