SSAS Tabluar CSV Import with 3011 error code

Siying 1 Reputation point
2021-01-20T08:21:05.553+00:00

Hello,

I'm trying to build a Tabular OLAP model. And 1 of the my data source is a csv file.

I uses Text File option from Table Import Wizard. After selecting the file, I was able to see the file content.
However, when I click on finish to start the import, I faced the below error message:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: The Microsoft Access database engine could not find the object 'file_name.csv'. Make sure the object exists and that you spell its name and the path name correctly. If 'file_name.csv' is not a local object, check your network connection or contact the server administrator.; 3011.
'.

Am I missing anything here?
Any help is greatly appreciated.
Thank you.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-01-21T06:27:24.433+00:00

    Hi,

    This 3011 error is not quite familiar to me , I did some search. Some information indicates that this may be caused by the the file name, which contains non-ASCII characters. Could you try to change the file name to some other character to see if it works. For example, you could change it to "test1" so on.

    Regards,
    Lukas


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments No comments

  2. Siying 1 Reputation point
    2021-01-22T03:47:48.687+00:00

    Hi Lukas,

    I tried your method, but still face with the same issue.
    I uses Service Account Impersonation and the file is located on the local server's E Drive. Could it be some permission or DSN that I'll need to set up prior to importing?

    Thank you.