cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
milo1234
Frequent Visitor

Missing subfolders not imported into Power BI from Outlook

Hi, 

 

I have connected my Microsoft Exchange account with Power BI, however there are missing subfolders which have not been imported. These are simple subfolders with normal emails inside. Please can someone help? 

2 ACCEPTED SOLUTIONS
milo1234
Frequent Visitor

Hi @Jimmy801 The Meeting Requests and Inbox folders were connected however the Meeting Cancellations, SPP008 and SPP009 were not. image.png

View solution in original post

Hello @milo1234 

 

but this what your are showing has nothing to do with your mail-folders. This are the different objects available in your mail account. This subfolders you can find in the table "Mail" and filtering the column "Folder path".

Hope I was clear enough

 

Spoiler
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

7 REPLIES 7
milo1234
Frequent Visitor

Hi @Jimmy801 The Meeting Requests and Inbox folders were connected however the Meeting Cancellations, SPP008 and SPP009 were not. image.png

View solution in original post

Hello @milo1234 

 

i cannot reproduce this. Can you do the following.

- connect to mailbox

- right-click on the column "Folder path" and choose remove other columns

- right-click again and choose Remove duplicates

 

Please sent me a screenshot of that and check if there are none of the folders above.

Other stupid question: Are there mail inside in this missing folders?

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

Hi @Jimmy801 

 

I have completed your steps above however the missing folders are still not found. 

The Meeting Cancellation has one cancellation email within the folder and the SPP008 and SPP009 folders contain several emails. 

image.png

Hello @milo1234 

 

sorry, but I have difficulties to follow you. You were saying that the folder meeting cancellations, SPP008 and SPP009 are missing, but I can see them in the screenshot. So they are imported

Jimmy801_0-1614160946559.png

means there are imported mails from this folders. So there should be no problem

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

Hi @Jimmy801 I cant see the folders on the right hand side of Power BI? 

I cant seem to access them 

 

milo1234_0-1614161289844.png

 

Hello @milo1234 

 

but this what your are showing has nothing to do with your mail-folders. This are the different objects available in your mail account. This subfolders you can find in the table "Mail" and filtering the column "Folder path".

Hope I was clear enough

 

Spoiler
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

Jimmy801
Super User III
Super User III

Hello @milo1234 

 

I checke this with my mailbox and I saw all of my folder. Independingly if was a subfolder of the inbox-folder or another folder on the same level as the inbox. Can you show me which folder of your mailbox is not in import of power query.


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.