Forum Discussion

Deepak's avatar
Deepak
New Member
9 years ago

how to limit email data source to specific folder

Hi Guys,    Hope you can help me with this one.   I have a report that is currently using an Exchange Online data source to collect emails, however as the mail box is fairly large, i would like t...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi Deepak,

 

According to my test, the step "#"Filtered Rows"" in your codes seems to be failed. It looks like this in my test:

 

#"Filtered Rows" = Table.SelectRows(Mail1, each ([Folder Path] = "\Drafts\"))

There are only one row in my test, so the refreshing is very fast.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

NEJO's avatar
NEJO
Advocate I
8 years ago

I also get this exact same issue.

 

Its not that the filter within the steps don't work, but when you apply the steps - and it starts the download, I can see it running through all of the folders initially rather than just going to the selected set of folder.

 

My guess is that its step 1 and 2 which still require the entire dataset to be pulled into the query for it to then be filtered.

 

Is there a way around this, so we can select at source a specific folder, as without I seem to be struggling and have to wait an hour for the full dataset to download to enable me to apply any new steps.

 

Thanks

Neil

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello Everybody,

     

    As Nejo said, filters have no effect and when you apply them, all mails are load first and then it is filter. 

     

    So during refresh or loading you can see PBI desktop running through all of the mailbox folders initially rather than just going to the selected set of folder. 

     

    Did anyone find a work around to avoid this loss of time?

     

    Kinds Regards, 

     

    Marius

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Got the exact same problem