Power Platform Community Forum Thread Details

Hi all,

I need to automatically transform Excel files and save the result as csv. The transformations needed may change often as the Excel sourcefile is subject to change. I can accomplish those transformations easily with Power Query.

I have already created a Dataflow in PowerBI that is connected to the OneDrive Folder and does the transformation needed.

This is the workflow I would like to achieve:

1. a User drops the Excelfile in a specific OneDrive Folder

2. the Dataflow refreshes the the Data

3. the result of the Dataflow/PowerQuery transformation is saved in this folder as a csv file

Is there any way to accomplish this Power Automate? Can I access the Dataflow from within a PowerAutomate Flow? Or is there a much better way to solve such a problem?

Thanks for any help!

Categories:

Building flows