none
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