Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Dataflows to get data from Azure to Dataverse

Hi All,

I have some data stored in my Azure container within many subfolders as a parquet file. I want to interact with this data and update it. I am trying to move this parquet file data to Dataverse using Dataflows using the ADLS Gen 2 connector but the Power Query does not provide me the capability to navigate to my file which is buried inside many subfolders. I have also tried to place the file outside all subfolders but on connecting to the container the Power Query shows files that are available inside the top folders inside the container but not the ones that are outside any folders.

 

Can someone please guide me on how I can work around this. Also, if there is a better way to do the same thing, I am open to ideas.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Please explain what you mean by "interact with it" - are you planning to write to the Parquet files?

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    Ideally yes, but alternatively, I am moving the data to dataverse and then I can perform crud operations on dataverse. If there is a way I can update the data in parquet files I would want to do it.