I wan to prepare a model in SSAS - Tabular using csv files placed in SFTP Folder.
Is there any way I can connect to these CSV files as a source to my SSAS - Tabular Model?
If not, what are options I have to get the them to my model?
PS: I want to use them in PowerBI Report but cannot connect them directly due to size of the files.
Thanks in advance. Regards,
Yes you can load csv files into Tabular, or if your compatibility mode supports it use the Power Query interface in SSDT.
The other option if you are using Azure Analysis Services is to use Azure Data Lake to store your files
However, it would always be best to have a defined process to load them into a database first, for example using SSIS or Data factory then load them into SSAS or Power BI that way, using Direct Query if they are to big for the Power BI file and or data model size limits
