Forum Discussion
PBI Dataflows Folder data source & custom columns
Twice my searches have led me to this thread - similar problems seemingly.
Another vote for adding 'Folder' as a Datasource option. Is it meaningful to start suggested-votes for these, or no since parity is the goal anyway...?
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)...
Blast from the past here -
For loading all the files in a folder: I tried copying all of the advanced editor M code in a Dataflow blank query, but got the following error. Pretty sure that's because the Sample Queries that are also produced when merging files, obviously aren't present.
How did you get around that?That's correct you'll need to copy in all the individual queries generated by Power BI when combining files from a Folder data source.
Yes. this is very tedious. I posted on the Ideas forum so that PQW automatically imports query dependencies, like happens when you copy/paste between desktop apps:
