Forum Discussion

bebeto's avatar
bebeto
Icon for Helper III rankHelper III
9 years ago
Solved

Append new data from json to an existing data model

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!

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    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.