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!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors