Caching table in BI

[thampton]

Here is my situation - im an connecting to a table in SQL server. This table is purged of records at night and loses the identifier i am using for some metrics. 

Is there a way i can cache this table every night in PBI before it is purged so i do not lost the records? I can take care of the duplicates after the fact? 

[v-piga-msft · Accepted solution]

Hi @thampton,

Is there a way i can cache this table every night in PBI before it is purged so i do not lost the records? I can take care of the duplicates after the fact? 

---

I'm afraid that we're not able to cache this table every night in PBI before it is purged so i do not lost the records. It seems that Power BI is not supported this feature currently.

Best Regards,

Cherry