Append new data from json to an existing data model

[bebeto]

Hi,

I have a model in Power BI and I want to add new data incrementaly to the principal data table. How can I deal with that? Weekly I want to add the new data (it is in a json file) to my model in Power BI Desktop.

Thanks in advance!

[MarcelBeug · Accepted solution]

Check this blog from TheBiccountant @ImkeF

[Greg_Deckler]

Currently that is not necessarily the easiest thing in the world to do. What you might do is have your initial principal query and load that and then disable refresh. Then, create a Folder (Combine Binaries) query for the JSON files, 1 per week. Then, create an Append Query as New query to append the principal query and your folder query.