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 jus...
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.

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity 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.