Calculated columns + Azure Synapse Link != true
The article discusses the behavior of calculated columns and formula columns in Dataverse and how they work with Azure Synapse Link. These columns are calculated on-the-fly every time Dataverse accesses them, which can cause unexpected behavior when using Azure Synapse Link. The article suggests moving calculations to the datalake if they are only used there. The author also provides a link to an idea for product improvements and warns about unexpected behavior in other integrations based on "modified on" or change tracking without periodic synchronizations.
Article 21m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time