Get data from SQL database

[szablock]

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

Slawek

[Anonymous]

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.

[Anonymous]

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.

[v-yuezhe-msft]

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]

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]

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

[szablock]

Any clue ?

[szablock]

Problem is with login as diffrent user to sql instance

[szablock]

Today I got diffrent error masage when I try to get to database

I can easylly conect via Managment Studio to this SQL instance.

Regrds,

Sławek

[v-yuezhe-msft]

Hi @szablock,

Do you install SSMS on the same machine  that installing Power BI Desktop?

In Power BI Desktop, go to “File –> Options and Settings –> Data Source Settings->Global permissions” , select  SQL Server data source , then clear permissions and re-connect to it from Power BI Desktop.

If the error still persists, please follow the instructions in the following blog to troubleshoot it.
https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-erro...

Thanks,
Lydia Zhang

[mbernstein]

I am having the same issue.  I'm using windows authentication for a locally installed SSMS, and connection to the same SQL instance is no issue there.  When I attempt to Get Data in PowerBI using windows authentication for the same server and SQL instance, I get this error: Details: "An error happened while reading data from the provider: 'System.IO.FileLoadException'"

Does anyone have other ideas?

[cassels]

I was having the same issue, I just got to load the database after I run PowerBI as a different user (the same I as using at SQL). After that, it worked.

It should work at PowerBI using the second option, but Idk why, only worked that way.

[szablock]

[szablock]