You’re offline. This is a read only version of the page.
Announcements
77
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!
I think my initial post may be a bit confusing...
The bottom line is that I would like to use power automate to make some transformations to an excel file that is being save to specific OneDrive folder and than save this as a csv file (in the same or a different folder).
I would like to use PowerQuery (from within a PowerBI Dataflow) to make the transformations to the excel file as this is exactly what PowerQuery is fantastic at.
However if there is a better approach to this I am happy to try something different!
Thanks!!
Share
Report
All responses (
Answers (
