powerbi e-mail 60k records how to update

ringmaster

New Member
Joined
Sep 1, 2005
Messages
13
Hi all need some help with powerbi and power query.
I have an group e-mailbox with 60k+ e-mails and grows every day.
I tried to import all emails to powerbi desktop, it works but its very slow 20 minutes or more for reading the box to pbi..
Every update of the query pbi runs again for 20 minutes or more.
So i tried an other option import the emails to excel with power query and save it and import this file to powerbi.
That works and is fast.
But how do i update the data with new e-mails every day ?
If possible realtime.
Who can help?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,108,998
Messages
5,526,161
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top