cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Import into CDS from ftp or onedrive

Hi all,

 

Super happy about CDS and importing from on-prem sources; lots of scenarios just work OOTB.

 

But I can't seem to find a way to import from (S)FTP for eg, and a way to make the `import from a folder` work from OneDrive (works fine from on-prem).

 

Thanks!

 

 

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Import into CDS from ftp or onedrive

Hi Catalin,

 

Looking through your issue it appears that this is not supported. Our documentation below shows that the import data must either be in csv, xml, or text files. it might be possible to come up with a work around but I would contact Microsoft Customer Support to help delve farther into coming up with a workaround for your data specifically. 

 

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/prepare-source-files-import

 

You can find out how to create a ticket here if you would like to go down that path: 

https://docs.microsoft.com/en-us/power-platform/admin/get-help-support

 

Regards,

 

Alex

 

-------

 

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Frequent Visitor

Re: Import into CDS from ftp or onedrive

Thakns Alex for looking into the issue, but i am not sure why you mention data format.

I'd be happy with any data format as long as i could import from ftp or from onedrive folders.

Continued Contributor
Continued Contributor

Re: Import into CDS from ftp or onedrive

You should be able to import from OneDrive - how far do you get, and do you get an error you can share ?

For ftp, are you trying to get a file from an ftp server, and then import it ? If so, I think you'd need to do this in 2 steps; first download the file using ftp to a file location, then import it. It's fairly easy to script the ftp download if necessary

 

Highlighted
Frequent Visitor

Re: Import into CDS from ftp or onedrive

Hi David,

 

Regarding OneDrive, i was not able to find a import from folder over OneDrive, just import 1 file.

 

On FTP, I got it to work in 2 steps; using a Flow, i read from FTP, drop into a storage account, from where i do a import data flow, but it's quite cumbersome. Can't understand why FTP could not be used as a data source for import DataFlows.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,383)