Forum Discussion
DataVitalizer
Super User
Super UserBuild a dataflow from Onedrive folder
Hi Community, Can anyone please confirm if Power BI Service allows combining files from OneDrive Folder using Dataflow? Error messages I got "Expression.Error: The parameter is expected to be of ty...
DataVitalizerSuper User
Super UserHi, I succeeded at listing the onedrive subfolder, but when expanding the files column content I get only one file in the output result plus I fail at saving the datalow because of aan error messgae about certain existence of a dependency.
Any suggestions?
ibarrauSuper User
Super UserFor combining files automatically, you need the files to be stored at the same folder. Otherwise you need more expertise at Power Query in order to filter from all files the ones you want, add a column to read the tables, and combine them. That would work if the columns match to combine.
Regards,
- DataVitalizer
Already done, but looks that the online version does not allow expanding many tables (files) at once