locked
Excel 2013 Power Pivot Error RRS feed

  • Question

  • 64 bit machine

    Enterprise Windows 7

    Office 2013 32 bit

    Excel 2013

    I have admin rights on the machine

    I created a set of queries in Power Query.

    I want to access the queries (in multiple tabs) from Power Pivot as my data sources

    I opened a new Excel file, Opened Power Pivot

    I clicked the Manage Data Model button

    I clicked From Other Sources in "Get External Data"

    I clicked Excel and browsed to the excel file with the Power Query query files

    I select the file and click test connection

    and I get an error "Failed to connect to the server. Reason: Unspecified error"

    This is a local excel file I created. I have rights to it!

    I once fixed this by enabling all SQL services I could find. But that is not working now.

    Help!

    Full message below: 

    ============================

    Error Message:
    ============================

    Unspecified error
    ----------------------------
    Failed to connect to the server. Reason: Unspecified error

    ============================
    Call Stack:
    ============================

       at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
       at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.OleDb.OleDbConnection.Open()
       at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
    ----------------------------
       at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
       at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.Open(String& connectionIdentifier)
       at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.Open()
       at Microsoft.AnalysisServices.Common.DataSourceBasic.TestConnection()
       at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl)

    ============================

    Wednesday, July 1, 2015 11:00 PM

Answers

All replies

  • Hi David,

    Thank you for your question. 

    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 
    Thank you for your understanding and support.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, July 13, 2015 12:55 AM
  • Any news on this?

    I am experiencing the exact same unwanted behavior and I am really curious about the solution.

    Wednesday, September 2, 2015 9:39 AM
  • David,

    Please send a Frown to the team or use Power BI User Voice to submit your feedback!

    Thanks!


    Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Friday, July 29, 2016 9:06 PM