Forum Discussion
Power ParticipantUsing Dataflow Gen2 to query CSV files in a Lakehouse
Thanks for your reply. I got it working in the end. After I closed chrome and relaunched it it showed the csv files went to get data. I think it was an error on my end. Just a note for anyone who is wondering. Inorder to transform multiple csv files at once (assuming they have the same layoiut) I had to create a dataflow, query the files one by one using the get data (within the same dataflow) and then apply the transformations accordingly then nest it inside a pipeline.
Microsoft EmployeeHi HamidBee
Apologies for the issue that you are facing here.
I tried to repro the same scenario from our end and didn't find any issue in viewing csv files in Get data.
Lakehouse that contains csv files.
Able to see the csv files in Get data.
Try to click the arrow on the left side of the Files and check whether you are able to see the files. If not could you please send me the screenshot of the Get data after clicking the arrow?
If issue still persists please do let us know.
I hope this information helps.
Power ParticipantThanks for your reply. I got it working in the end. After I closed chrome and relaunched it it showed the csv files went to get data. I think it was an error on my end. Just a note for anyone who is wondering. Inorder to transform multiple csv files at once (assuming they have the same layoiut) I had to create a dataflow, query the files one by one using the get data (within the same dataflow) and then apply the transformations accordingly then nest it inside a pipeline.
- v-cboorla-msft
Hi HamidBee
Glad that your query got resolved.
Please continue using Fabric Community for any help regarding your queries.