Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
vpserefin
New Contributor II

start.datetime is NULL for CalendarView object from Microsoft Data Connect

I am trying to extract all calendar data(BasicDataSet_v0.CalendarView_v0) using our Microsoft 365 connector and Grap Data Connect app  using Data Pipeline on Microsft Fabric. I am able to get data in some fields but the start.datetime is always NULL. Can you please help me why this is happening. Followed the instructions from here:

https://learn.microsoft.com/en-us/graph/app-registration

https://learn.microsoft.com/en-us/graph/data-connect-quickstart?tabs=AzureSynapsePipeline&tutorial-s...

https://learn.microsoft.com/en-us/entra/identity/enterprise-apps/configure-admin-consent-workflow

 

I have also added the following consents to the app.

 

vpserefin_0-1720729120007.png

 

I had earlier created a post in the wrong forum: https://community.fabric.microsoft.com/t5/General-Discussion/start-datetime-is-NULL-for-CalendarView...

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @vpserefin,

I'd like to suggest you check if these missed value fields are custom fields.
AFIAK, the official data connector only picks the original table fields, these custom fields did not include in the results.
For this scenario, you may need to use the custom fields related REST API to get these fields from the data source.

Regards,

Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @vpserefin,

I'd like to suggest you check if these missed value fields are custom fields.
AFIAK, the official data connector only picks the original table fields, these custom fields did not include in the results.
For this scenario, you may need to use the custom fields related REST API to get these fields from the data source.

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
Users online (2,084)