Unable to get data from folder in dataflow Gen2 from Data Factory in Microsoft Fabric

ricardojgmateus — Sat, 29 Jun 2024 09:08:02 GMT

I want to get data from files located in a local folder using dataflow Gen2 in Data Factory from Ms Fabric.

I am able to do it Ms Power BI Desktop.

However, unlike PBI Desktop, in Data Factory, I cannor see the Browse button (see image)

I tried to copy and paste the respective path to the respective box, but the "Next" button is not activated so that I can proceed.

Any suggestions to solve this issue?

Re: Unable to get data from folder in dataflow Gen2 from Data Factory in Microsoft Fabric

frithjof_v — Sat, 29 Jun 2024 09:35:54 GMT

Maybe you need an on-prem data gateway to do this, because the file seems to be on your local computer.

Or place the file in OneDrive / SharePoint first, then you don't need the on-prem data gateway.