Forum Discussion

caantjes's avatar
caantjes
Frequent Visitor
10 years ago
Solved

Data Refreshes (gateway or desktop)

 

I am using the Gateway to daily refresh data.

The tables however contain a lot of history and it looks as if the refresh will replace all old data with new.

What is a recommended approach to just append new data ?

Can the refresh process be configured to just look for the delta rather than all ?

The current refresh took over 90 minutes which I know if not necessary.

 

Thanks in advance,

Corne

Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    caantjes Unfortunately data refresh in power bi currently is only full refresh and not delta. Below is one way you can limit data refresh.

     

    If using sql server or other database such as Oracle you have option to enter sql queries and using that you can limit amount of rows that you bring which will also apply to data refresh such as only rows where datetime stamp is within past 30 days.

3 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    caantjes Unfortunately data refresh in power bi currently is only full refresh and not delta. Below is one way you can limit data refresh.

     

    If using sql server or other database such as Oracle you have option to enter sql queries and using that you can limit amount of rows that you bring which will also apply to data refresh such as only rows where datetime stamp is within past 30 days.