Unable to get data from MS Graph integretion

TomasBillesand — Wed, 12 Jun 2024 05:52:27 GMT

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

Re: Unable to get data from MS Graph integretion

Anonymous — Wed, 12 Jun 2024 16:41:40 GMT

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

Re: Unable to get data from MS Graph integretion

TomasBillesand — Fri, 14 Jun 2024 08:00:18 GMT

Hi,

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

BR Tomas

topic Re: Unable to get data from MS Graph integretion in Pipelines

Unable to get data from MS Graph integretion

Re: Unable to get data from MS Graph integretion

Re: Unable to get data from MS Graph integretion