Forum Discussion
PowerBI - Use R to export data from dataset in Power BI Service
Hi Mannu,
It could help if you can archive the old mails. As far as I know, there isn't a special limit for the data from MS exchange. Please refer to this post.
Yes, the incremental refresh is planned. Please refer to this idea. But as I mentioned before, the incremental refresh couldn't help in your scenario. For example, the exchange only have data of 2016 and 2017. The Power BI could consider the data before 2016 invalid. Because the Power BI has to make the result accurate and helpful. (The final result depends on the design).
The workaround could be storing all the data first then sending to Power BI.
Best Regards,
Dale
Thanks again Dale v-jiascu-msft
Ability to connect with .pst file is still an idea (so archival will not help me). If .pst files (archived files) could be accessed from PBI, it would have been easier to maintain it on One Drive and then we wouldn't have to worry about data refresh !!!
But alas, at this juncture I think we need to store information on a different system and pull this data into Power BI :-( Complex and time consuming!! And for all our efforts, if this feature is made available soon after... would drive me crazy !!!
:-)
Thanks for your help again
Regards,
Mannu