Forum Discussion

mark_carlisle's avatar
mark_carlisle
Advocate IV
7 years ago

PBI Dataflows Folder data source & custom columns

Appreciate that Dataflows is currently in Preview so not expecting everything immediately. Could I just ask the following;   Are custom columns going to be available as an option within the in fut...
Need Help
mark_carlisle's avatar
mark_carlisle
Advocate IV
7 years ago
I've not tested CSV from OneDrive but I've found you can't save Data flows that have duration column types.
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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)...

    • mark_carlisle's avatar
      mark_carlisle
      Advocate IV
      7 years ago

      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?