Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Syndicate_Admin
Administrator
Administrator

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 2
Syndicate_Admin
Administrator
Administrator

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.

lbendlin
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors