none
Taking Long Time to Load/Import Table into Visual Studio RRS feed

  • Question

  • Hi,

    I am trying to create model in Visual Studio 2017, compatibility 1400 from Data Lake Store. The file in *.csv format. Success to connect to the connector, however it takes long time to load a table into the model. The size range between 300-400MB. Looking to improve the loading. 

    Thanks.

    Thursday, September 20, 2018 8:32 PM

All replies

  • how long does it take?
    Thursday, September 20, 2018 9:22 PM
    Moderator
  • Hello,

    Take a look at this blog:

    https://blogs.msdn.microsoft.com/analysisservices/2017/09/05/using-azure-analysis-services-on-top-of-azure-data-lake-storage/

    If you can split your data and load it in parallel, you may be able to see some performance gains.  

    Tuesday, September 25, 2018 10:30 PM
    Moderator