The connector models the data in FTP as a list of tables in a relational database that can be queried using standard SQL statements.
CData Power BI Connector for FTP Tables
|The root table. This table will always be available. Other tables are automatically detected by the TableDepth connection property.