enterprise refresh with csv files

[elsalvador182]

I have a collection of csv files stored on an ftp server that are exported from Salesforce. I want to use enterprise gateway so that I can have multiple users hit "refresh" and get the most up to date data from power bi (cloud).

question: 

1) I can also have the files stored locally on a machine using a thrird party program to pull and download. Can the enterprise gateway refresh using these locally stored csv files?

2) Can the enterpise gateway pull from ftp site (or website?)

Theres tons of articles on gateways but its still a littel fuzzy. help.

[Anonymous]

I can't speak to directly consuming on an FTP location but the enterprise gateway can consume CSVs on a folder if they are stored locally and UNC path qualified.  You can see this link for an example of how this can be done (Refreshing Power BI reports based off Excel data using the On-premises data gateway ).

For your scenario you would have to:

• Bring the files down using your third party tool.  Put them on a network share. 
• In Power BI Desktop use the Get Data option and select Folder.  Point to the UNC share.  Make sure you select to "Edit" and when the table is presented there will be column "Content" with "Binary" as the contents.  In the column header click the double down arrow icon.  That will convert the file listing to the actual contents.  You can do additional power query functions (such as Use First Row as Headers).
• Build out your report and publish it to the server.
• Establish a On-Premises Gateway connection of type "Folder" pointing at the UNC path.
• Finally on the "Dataset" in the Power BI Service, select Schedule REfresh, then set it to the Gateway connection.  YOu can also set a refresh schedule.

From there the data should refresh, or a user can select the dataset and Refresh.  This should work even if you change the number of files in the directory.

Hope this helps

[James1965]

Hi all,

I have the same problem, a collection of csv files stored on a ftp server with password!

I cann´t get data. I know that Power BI should work with ftp server. How? 

Thanks for answer!

James1965