Forum Discussion

TomasBillesand's avatar
TomasBillesand
Frequent Visitor
2 years ago
Solved

Unable to get data from MS Graph integretion

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

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      TomasBillesand
      Frequent Visitor

      Hi,

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

       

      BR Tomas