Hi ,
We have ingested Parquet formatted files into Customer Insights using the CI recommended Incremental refresh folder structure. All this works fine. Unfortunately we are unable to do any transformations within the Dynamics 365 Customer Insights upon this data. Is this normal, I would have expected to be able to do some transformation and data type conversions, what am I missing ?
Any help greatly appreciated!
Many thanks,
Mahesh
Or Power Query - SQL has a pretty rich set of transforms but tbh, I'd probably opt for PQ in general over SQL. They both get you there though.
Hi Bill,
Thanks for quick reply! It seems that, for transformation, we need to take synapse route then.
Thanks,
Mahesh
Mahesh, if you're doing the CDM mount, the transformations will need to be done in advance. Power Query is the only mechanism right now that'll let you do transformations on ingestion. One other possible way around it is to setup a synapse serverless pool, create views on those parquet files and you can do several of the transforms in the view definition, but if you're already this far down the path it's probably not an option.
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156