How to Combine Files in SharePoint Folder with a Dataflow

[Shelley]

Both this post https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-january-updates/ and this post https://docs.microsoft.com/en-us/power-bi/service-dataflows-data-sources indicate the capability to connect to a SharePoint Folder, using dataflows. I want to auto-combine files from a SharePoint folder, like I do in Power Query in Power BI. Is this possible in dataflows, and what specific steps must be taken to do this? I have set up the combining of files in Power BI and tried copying the scripting to a blank query, but there are other steps that Power Query creates that I cannot seem to figure out how to create in dataflows. See the Transform/Sample Query below.

[edhans · Accepted solution]

See this thread. Hopefully the UI will be able to handle this in the near future.

[Shelley]

Thanks @edhans as this put me on the right track to figuring out how to do it!