1


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,

Raj Jayaswal
  • 468
  • 1
  • 9
  • 22

1 Answers1

0

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

Jon
  • 4,593
  • 3
  • 13
  • 33
  • thanks for your reply. I could not see the option to connect to SFTP from visual studio. The files are in SFTP and I cannot copy them to local drive due to security issues. – Raj Jayaswal May 21 '20 at 12:32