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

caantjes's avatar
caantjes
Frequent Visitor
9 years ago

Hi, thanks,

 

I agree through Advanced Query I can filter the dataset in PowerBI to be limited to all dates beyond a certain date.  This limits the dataset in PowerBI Desktop and subsequent publishing in Cloud. 

This does however not really accomplish my goal. I would like the old data to remain present but untouched, and append to it. Now I loose the abiltiy to present the dashboard for months prior to the selected date. 

 

This sounds like a common request. Can you help me ?

 

 

Corne