Time to renew data input from outlook

[Anonymous]

Hi,

I have connected power bi with outlook through Microsoft Exchange Online. The connections works great!!

I have a problem when i renew the powerbi dashboard it renews all the data up to 2012 and it is very slow to renew each time. How can i fix this problem i just want the data of incoming emails.

Thanks!

[v-lili6-msft]

hi, @Anonymous 

You need to do some filter for your dataset in Edit Queries.

or If you have Premium license, you could try Incremental refresh in Power BI Premium.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Best Regards,

Lin

[Anonymous]

i only have powerbi pro. Filter in the dataset in edit queries do you have an exsample like a screen shot so i understand it beter thank you very much @v-lili6-msft 

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

Could you please tell me if have other problem? If not, could you please mark the helpful replies as Answered?  

Best Regards,

Lin

[v-lili6-msft]

hi, @Anonymous 

To deduce the dataset, you could filter useless data and column, optimize your data model, etc.

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

Best Regards,

Lin