Unable to get data from MS Graph integretion

[TomasBillesand]

Hi!

So, I followed the steps in Configure Microsoft 365 in a copy activity - Microsoft Fabric | Microsoft Learn in order to read data through MS Graph Data Connector. It seems to work just fine, no error messeges, pipeline execution time is about 25 mins and it creates a table in the lakehouse with all metadata such as columns and datatypes as expected. However, the table is empty.

This is the output from the pipeline execution:

{
"dataRead": 0,
"dataWritten": 0,
"filesWritten": 0,
"sinkPeakConnections": 1,
"rowsRead": 0,
"copyDuration": 1384,
"throughput": 0,
"errors": [],
"usedDataIntegrationUnits": 4,
"usedParallelCopies": 1,
"executionDetails": [
{
"source": {
"type": "Office365"
},
"sink": {
"type": "Lakehouse"
},
"status": "Succeeded",
"start": "6/5/2024, 6:28:14 AM",
"duration": 1359,
"usedDataIntegrationUnits": 4,
"usedParallelCopies": 1,
"profile": {
"queue": {
"status": "Completed",
"duration": 6
},
"transfer": {
"status": "Completed",
"duration": 1352
}
},
"detailedDurations": {
"queuingDuration": 6,
"transferDuration": 1352
}
},
{
"source": {
"type": "AzureBlobFS"
},
"sink": {
"type": "Lakehouse"
},
"status": "Succeeded",
"start": "6/5/2024, 6:50:54 AM",
"duration": 24,
"usedDataIntegrationUnits": 4,
"usedParallelCopies": 1,
"profile": {
"queue": {
"status": "Completed",
"duration": 8
},
"transfer": {
"status": "Completed",
"duration": 15,
"details": {
"listingSource": {
"type": "AzureBlobFS",
"workingDuration": 1
},
"readingFromSource": {
"type": "AzureBlobFS",
"workingDuration": 0
},
"writingToSink": {
"type": "Lakehouse",
"workingDuration": 0
}
}
}
},
"detailedDurations": {
"queuingDuration": 8,
"transferDuration": 15
}
}
],
"dataConsistencyVerification": {
"VerificationResult": "Unsupported"
}
}

Any ideas on how I should proceed? It is the BasicDataSet_v0.ConferenceRoomCalendar_v0 I am trying to get from Graph. My first thought was to check if the dataset in Graph is even populated to begin with. Any idea on how to do that?

BR Tomas

[v-nikhilan-msft · Accepted solution]

Hi @TomasBillesand 
Thanks for using Fabric Community.
For issues related to Microsoft Graph Data Connect, which is used to extract data from Microsoft 365, it would be more appropriate to reach out to Microsoft 365 support. They have the expertise related to Microsoft 365 services and can provide more specific guidance based on your setup and configuration.
https://www.microsoft.com/en-in/microsoft-365/support

[TomasBillesand]

Hi,

I did try to post in the M365 Community Forum and they asked me to post here instead.

BR Tomas