Forum Discussion
PowerBI - Use R to export data from dataset in Power BI Service
Hi, I need to persist data from MS exchange to 5 years while currently, only 2 years data is being saved on the server. This means I need to save all meta data pertaining to the reports in a DBM...
v-jiascu-msft
Yes. We can get the data directly from MS exchange. But then how do we maintain 5 years data?
We only have 2 years data on MS exchange at any point of time.
This is the reason we need a separate data store to maintain the information.
Yes we can use scheduled data refresh.
But as PowerBI doesn't do incremental refresh, we will lose out data prior to 2 years with every refresh
Yes. We can get the data directly from MS exchange. But then how do we maintain 5 years data?
We only have 2 years data on MS exchange at any point of time.
This is the reason we need a separate data store to maintain the information.
Yes we can use scheduled data refresh.
But as PowerBI doesn't do incremental refresh, we will lose out data prior to 2 years with every refresh
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
There could be another way to maintain 5 years or more data of exchange. But that won't be the duty of Power BI.
1. Can you extend the capability of the Exchange?
2. Can you archive the old mails?
3. Incremental refresh could be a good idea. But the records that don't exist in the data source should be considered as invalid data.
Best Regards,
Dale