Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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:
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
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