Forum Discussion

thampton's avatar
thampton
Icon for Helper III rankHelper III
7 years ago
Solved

Caching table in BI

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 t...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

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