PowerBI - Getting Data from Microsoft Exchange: Some Inbox sub folders (Outlook 365) not imported

[Data1]

Hi, 

I am making statistics for shared mailbox but noticed that inbox email qty does not match - is lower

So I found that the reason is that some sub folders in the inbox are missing in the list completely

Othervise missing folders are visible in both desktop app and office 365 online

[dax]

Hi Data1, 

You said that some sub foldera didn't appear in data, are these folders special? You could refer to Analyzing your Microsoft Exchange Account Data with Power Query  for details.

Best Regards,
Zoe Zhi

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

[Data1]

Zoe,

These are simple subfolders in the inbox

foe example:

Mail/Inbox/AAA

Mail/Inbox/CCC

are in folder list in Power BI but 

Mail/Inbox/BBB

Mail/Inbox/DDD

Mail/EEE

are not listed, so half of email count is missng in Bower BI statistics

[Data1]

Anyone has a clue how to fix?