cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cte_crest
Helper I
Helper I

Can we retain the data in the table, and add newly fetched data through refresh in custom connector?

Hi folks, I am thinking to develop a custom connector, in which I fetch the data through API. My use case is to keep on adding the data to the table. 

 

So, is that supported in Power BI custom connectors/template apps? I suppose, currently, whenever I press refresh, the data is deleted from the dataset and all the data is fetched again. 

 

Is that correct? Or I am getting it wrong?

2 REPLIES 2
Greg_Deckler
Super User
Super User

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler 

I think this approach will only work on Power BI desktop and is still isn't supported on Power BI service. Right?

 

Also, if I have a large dataset (Around 2.5 Million events daily fetched through API), do you suggest that I could leverage this approach?

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors