Forum Discussion
PBI Dataflows Folder data source & custom columns
mmace1 Just thought I'd mention that I've done some testing with a folder data source and PBI dataflows and it is possible to get it working.
You need to connect to the Folder data source in PBI Desktop and then copy each of the querries, along with the parameter and function from the Advanced Editior in PBI desktop in to a Blank query within dataflows. The only thing I had to do was to remove the Filtered Hidden Files step within the final query
Be great if MS add it as a source so the process is automated but this is an acceptable work around.
As I described in the post below, I have an issue where I cannot save a dataflow containing queries/parameters/function to get csv data from a folder - do you know if there is a way to fix it?
https://community.powerbi.com/t5/Service/Unable-to-save-a-dataflow-status-400/m-p/643658#M64081
Thanks in advance.
- I've not tested CSV from OneDrive but I've found you can't save Data flows that have duration column types.
Thank you for the response, I do not have any duration type columns (tried converting all columns to text but didn't resolve the issue)...
How are you connecting to the OneDrive folder? I was not able to connect to my OneDrive folder and combine files like I can when I use a (local) folder data source. This article (https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links) also suggests that you have to connectto each individual file and then merge/append as required.
Could you share your queries so I can understand how you are connecting to OneDrive?