Forum Discussion

mkw123's avatar
mkw123
New Member
5 years ago

Outlook - Generic mailbox - slow loading

HI, 

I am seeking your advice.

I am trying to connect the generic mailbox to the Power BI. As per the below m-code, I am only interested in the data 2020 onwards plus folders that = Inbox, =Sent Items, and any folder that contains Archive.

When I press save and load 1.5h ago from this moment, the data is still loading.

Am right to say that power BI is going through every individual item in the maiblox and then applies the m code to return the emails that meets the criteria? Would it be wise to move emails from 2020 onwards to one folder?

Could you please advise what could I do to speed up the loading?

The mailbox contains I think over 500K emails from 2013.

 




Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi mkw123 ,

     

    Power BI will traverse all the mails in the mailbox, filter and sort the imported data in the Power Query Editor, and finally import it into the model. These operations require a lot of space of memory and CPU, and if the speed of network is too slow, it will also lead to slow loading. In the import mode, the maximum number of rows in the table can reach 1,999,999,997. But the huge amount of data will make loading and refreshing very slow.

    My suggestion is to remove unnecessary data as much as possible when converting data, and reduce the amount of imported data in Power BI.

     

    Or you can try to create a mailbox database in Exchange Server to check your mailboxs.

    Manage mailbox databases in Exchange Server 

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.