How to do extract Dynamic 365 Dataverse to export Azure synapse link to store the csv format in azure storage

Karthik Elavan 1 Reputation point
2022-09-06T09:05:25.563+00:00

I am new to this technologies and trying to connect under azure power apps there is option to connect azure synapse link to configure the azure storage gen2 and once connected, what ever the azure CRM 365 tables available, i can see the each table in that new link which i was created in synapse link, after that the data loaded in azure storage but output totally changed. if i got normal crm to export excel data is different. i want to export data what ever the crm 365, i can see in storage as well with header. please help me.

I have to add or export with schema name(column as a header in that CSV file). and there is default partition is month, i have to change customization or remove the partition. please advise. how do we handle this.

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.
2,884 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 18,621 Reputation points Microsoft Employee
    2022-09-07T21:30:56.717+00:00

    Hello @Karthik Elavan ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is why the data which you seeing in the storage is different then the records which you see when export , please do let us know if its not accurate.
    I am not sure if the formating of the data which you are refering to here . If thats the case , I just wanted to let you know that the records in the storage are stored a bit differently called datavserse , please read about that here : https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-intro#dynamics-365-and-dataverse

    238782-image.png

    Please do let me if you have any queries.
    Thanks
    Himanshu


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators