Availability of BasicDataSet_v0.MailFolder_v2 when creating a linkedservice in Azure Data Factory

Matt 5 Reputation points
2024-09-10T01:26:55.4333333+00:00

Hi all.

I have been attempting to complete a pipeline that draws info on a shared mailbox. I started out with the BasicDataSet_v0.MailFolder_v0 Dataset but discovered that it does not give a breakdown of child folders nor does it include shared inboxes the user has access to.

I have not been able to see the BasicDataSet_v0.MailFolder_v2 as an available option in the Microsoft 365 LinkedService. I am unsure why this dataset is not visible despite it included in the official documentation. I haven't found any reason for the dataset to not be visible as an option as the regions correspond with the documentation and I have other datasets I am able to ingest without issue.

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,043 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,708 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 24,636 Reputation points
    2024-09-11T20:58:29.19+00:00

    It seems like you are encountering an issue where the MailFolder_v2 dataset is not visible in your Microsoft 365 Linked Service, despite the documentation suggesting that it should be available :

    1. Dataset Availability: The availability of certain datasets, like MailFolder_v2, can sometimes depend on the version of the API or service you're using. Make sure you're using the most up-to-date version of the Microsoft Graph API in your ADF configuration.
    2. Permissions Check: Even though you've confirmed the necessary permissions, double-check that your app registration (used in the ADF Linked Service) has the correct Microsoft Graph permissions. The permissions required for MailFolder_v2 may differ slightly from MailFolder_v0, especially for shared mailboxes. Make sure permissions like Mail.Read.Shared, Mail.ReadBasic, or Mail.Read are included and consented by an administrator.
    3. Service Principal Issues: If you’re using service principals to authenticate, ensure that the service principal has access to shared mailboxes. Sometimes, shared mailbox access is restricted to user-based authentication, which might cause issues in displaying the correct datasets in ADF.
    4. Review Documentation/Updates: Sometimes, dataset availability can change based on updates to the ADF integration with Microsoft 365. Double-check recent Microsoft Graph and ADF release notes to confirm that there are no limitations or issues with MailFolder_v2 in shared mailbox scenarios.
    5. Dataset Visibility Configuration: There might be a configuration issue preventing MailFolder_v2 from showing up in your linked service. You can try removing and re-adding the linked service in ADF to see if that triggers the visibility of the dataset.

    If none of these solutions work, it could be worth reaching out to Microsoft support to confirm if there are any ongoing issues or undocumented requirements with accessing the MailFolder_v2 dataset in the M365 Linked Service.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.