Forum Discussion

szablock's avatar
szablock
Icon for Helper I rankHelper I
9 years ago

Get data from SQL database

I try to get date from sql and I got that information

 

 

Slawek

Need Help

13 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi szablock,

    Please firstly install SQL Server Management Studio(SSMS) on the same machine that have Power BI Desktop installed, then use SSMS to connect to the SQL Server and check if it is successful.

    If there is no connection  issue using SSMS, please go to File -> Options and settings -> Options -> Diagnostics in Power BI Desktop and click "enable tracing", then connect to SQL Server database and check the detailed logs in the traces folder. Also please help to post the detailed logs here.


    Thanks,
    Lydia Zhang

    • szablock's avatar
      szablock
      Icon for Helper I rankHelper I
      9 years ago

      Log contetnt

       

      DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9370495Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":4,"Duration":"00:00:00.0004806"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9409176Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0158829"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9568545Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0000915"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9568742Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":4,"Duration":"00:00:00.0001203"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9569628Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":7,"Duration":"00:00:00.0052352"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9575178Z","Action":"CredentialExtensions/GetImpersonationWrapper","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0617715"}
DataMashup.Trace Error: 24579 : {"Start":"2016-12-14T12:27:30.0224864Z","Action":"Engine/IO/Db/SQL/ProcessException","Exception":"Exception:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0003964"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.0209194Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0020341"}
DataMashup.Trace Error: 24579 : {"Start":"2016-12-14T12:27:30.0209044Z","Action":"Engine/IO/Db/Microsoft SQL/ExecuteReader","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] An error happened while reading data from the provider: 'System.IO.FileLoadException'\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.<>c__DisplayClass1.<Execute>b__0()\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at

       

      Regards

      Slawek

      • szablock's avatar
        szablock
        Icon for Helper I rankHelper I
        9 years ago

        Part 2

         

        Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0022909"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.0209004Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0023722"}
DataMashup.Trace Warning: 24579 : {"Start":"2016-12-14T12:27:30.0208873Z","Action":"Engine/IO/Db/Microsoft SQL/NativeQueryTableValue/Execute","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] An error happened while reading data from the provider: 'System.IO.FileLoadException'\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.<>c__DisplayClass1.<Execute>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Execute(String commandText, CommandBehavior commandBehavior, Value parameters)\r\n   at Microsoft.Mashup.Engine1.Library.Common.NativeQueryTableValue.Execute(ConnectionReader connectionReader)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0025505"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.0246686Z","Action":"CredentialExtensions/GetImpersonationWrapper","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0819116"}
DataMashup.Trace Error: 24579 : {"Start":"2016-12-14T12:27:30.1091270Z","Action":"Engine/IO/Db/SQL/ProcessException","Exception":"Exception:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0000832"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.1069623Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0023916"}
DataMashup.Trace Error: 24579 : {"Start":"2016-12-14T12:27:30.1069532Z","Action":"Engine/IO/Db/Microsoft SQL/ExecuteReader","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] An error happened while reading data from the provider: 'System.IO.FileLoadException'\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.<>c__DisplayClass1.<Execute>b__0()\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0024958"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.1069496Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0025374"}
DataMashup.Trace Warning: 24579 : {"Start":"2016-12-14T12:27:30.1069350Z","Action":"Engine/IO/Db/Microsoft SQL/NativeQueryTableValue/Execute","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] An error happened while reading data from the provider: 'System.IO.FileLoadException'\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.<>c__DisplayClass1.<Execute>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Execute(String commandText, CommandBehavior commandBehavior, Value parameters)\r\n   at Microsoft.Mashup.Engine1.Library.Common.NativeQueryTableValue.Execute(ConnectionReader connectionReader)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0026552"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9409070Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.1686963"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9381723Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0187963"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9569854Z","Action":"RemotePreviewValueSource/RunStub","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.1527751"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9381052Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"49","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.1716837"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.1097587Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":4,"Duration":"00:00:00.0000408"}

        Regards

         

        Slawek

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Interestingly, the 'use alternate credentials' did not work unless I launched Power BI via 'Run as Adminstrator'.   I could then use someone else's credentials and it would work.  Otherwise got the IO error.  

    - Using AD Group on the a 2008 SQL db at Login and db User level.  

    - Running Power BI from my local machine

    - SSMS connected fine (using my credentials) from local machine.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Interestingly, the 'use alternate credentials' did not work unless I launched Power BI via 'Run as Adminstrator'.   I could then use someone else's credentials and it would work.  Otherwise got the IO error.   Maybe worth a try....

    - Using AD Group on the a 2008 SQL db at Login and db User level.  

    - Running Power BI from my local machine

    - SSMS connected fine (using my credentials) from local machine.