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

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

1 Reply

  • 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