Forum Discussion

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Why not retrieving data from MS exchange directly? I'm afraid these items are hard to achieve. Power BI collects many data together and brings out many wonderful insights. These requirements here are in the opposite direction. 

1. The item 4 is already in the Power BI Service. You can set the Scheduled Refresh in the Settings. 

2. Please refer to power-bi/developer/what-can-you-do.

3. If you want these features, please create an idea here.

 

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago
    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
    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Dale v-jiascu-msft

         

        Thank you for looking into this problem.

         

        At this point, I have a very broad set of requirements.

        I will be looking into Global mailbox and it would be safe to assume that archival is not possible.

         

        However I would like to know how it can help if archival is enabled.

         

        By extending the capability of exchange, if you meant "increasing the duration of data stored on MS Exchange"  the answer is - "No"  it is not feasible.

         

        Is there a way I can implement incremental refresh or is it planned for upcoming update?

        I suppose this feature is not yet supported on Power BI

         

        Thanks,

        Mannu