Notifications
Announcements
No record found.
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
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.
Hi Bill,
Thanks for quick reply! It seems that, for transformation, we need to take synapse route then.
Thanks,
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 137 Super User 2025 Season 2
#ManoVerse 57
Jimmy Passeti 50 Most Valuable Professional
