Mapping data flow in synapse missing attributes values when reading a REST data set

Paul Hernandez 546 Reputation points Microsoft Employee

Hi everyone,

this is really weird, I am reading AAD groups using the graph API from a mapping data flow using a REST dataset:


The projection is as expected:


The "renewedDateTime" attribute sometimes has values and sometimes is completely empty in the data preview:


When values are available (I don't know how is that possible), they disappear in the flatten transformation.

Any ideas what could be wrong?

The examples in the documentation cover only string attributes.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,569 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,058 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Zehui Yao_MSFT 5,711 Reputation points

    Hello,@Paul Hernandez , the property is only updated via the renew service action.
    Here is the documentation for reference:

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.