Unable to Connect to SQL Server

[caracarn]

I am trying to connect to an internal SQL Server.  As suggested on other threads I found here, I have loaded SSMS on my machine and can successfully connect to the DB that way.  I have cleared out the connecton information in PowerBI and tried again.  Am just using Windows Authentication and getting Details: "An error happened while reading data from the provider: 'System.IO.FileLoadException'"

This is on a SQL Server 2008 R2 server.

[jcolares]

I had a similar problem. I was able to connect to an instance of MSSQL, but not to an other, which showed the error message mentioned above. I solved the problem by running PowerBI Desktop as administrator.

[Sébastien-JLD]

Hi Jcolares,

Thanks a lot for your post. The connection to the SQL Server is ok but I am still not having any view of the databases and Power BI still tell me that the user is not auhtorised. I've tried with SQL login or Windows login administrator of the Database and same problem. The remote connection on the database is well enabled.

[MJVPBI]

This just started happening to me too.

I have version Version: 2.43.4647.541 64-bit (February, 2017) installed.

The first database I connected to when I first installed worked just fine for weeks.

Then, today, I tried to connect to a different server and this error started to happen.

Now, I cannot connnect to any server, even the original one.

This is not an issue of permissions of any kind, nor of any database settings such as allow remote connection/login.

I have two trace files for you, but I cannot see anywhere to load an attachment, and only one will fit in this post.

Here is file (Microsoft.Mashup.Container.NetFX40.7900.2017-03-03T18-42-54-198131.log)

DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2570565Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":16,"Duration":"00:00:00.0026425"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2581047Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0057521"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2639278Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0002807"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2659280Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":16,"Duration":"00:00:00.0002288"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2657995Z","Action":"CredentialExtensions/GetImpersonationWrapper","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0372305"}
DataMashup.Trace Error: 24579 : {"Start":"2017-03-03T18:42:54.3108133Z","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.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0272186"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3098370Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0285287"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3093584Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0296035"}
DataMashup.Trace Error: 24579 : {"Start":"2017-03-03T18:42:54.3407557Z","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.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0002405"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3401397Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0010471"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3399958Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0014186"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2580756Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0831198"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2574493Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0068143"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2643074Z","Action":"RemotePreviewValueSource/RunStub","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0777113"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2572071Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"11","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0848898"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3422285Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":16,"Duration":"00:00:00.0002062"}

[JamesHinton]

It seems that your data source settings may have changed.  Go to File, Options and Settings, Data Source Settings, and check/confirm Credentials, Encryption (set it to Off) and Privacy Level (try None).

[Sébastien-JLD]

Good afternoon,

I am a new Power BI user and cannot connect as well to a database on the SQL Server. I have the following error and I don't know where to find the solution. Thanks a lot for your help :

« Une erreur s'est produite pendant la lecture des données du fournisseur : 'Impossible de charger le fichier ou l'assembly 'System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' ou une de ses dépendances. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception de HRESULT : 0x80070542)' »

[JamesHinton]

Hi Sebastien,

Unfortunately I am not a SQL expert.  However,

have you confirmed that the credentials you are employing do in fact allow a remote connection to the SQL Server?

Regards,

James

[Sébastien-JLD]

Hi James,

Thanks for your post. Yes, the credentials used is able to make a remote connection and it is the administrator of the SQL Server.

[MJVPBI]

this just started happening to me too.

I originally connected to our dev server, and did a bunch of stuff.

The minute I tried to connect to another server, this error started happening.

Now, I cannot connect to any server, not even the original one I have been working with for weeks.

Something got corrupted somewhere.

I have attached my trace files

This is probably not a permissions problem, or an allow remote connections problem.

I did not see a way to attach files, so I am only able to past the data from the first trace file. 

Thanks,

Michael

Outut from first trace file (Microsoft.Mashup.Container.NetFX40.7900.2017-03-03T18-42-54-198131)

DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2570565Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":16,"Duration":"00:00:00.0026425"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2581047Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0057521"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2639278Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0002807"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2659280Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":16,"Duration":"00:00:00.0002288"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2657995Z","Action":"CredentialExtensions/GetImpersonationWrapper","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0372305"}
DataMashup.Trace Error: 24579 : {"Start":"2017-03-03T18:42:54.3108133Z","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.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0272186"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3098370Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0285287"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3093584Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0296035"}
DataMashup.Trace Error: 24579 : {"Start":"2017-03-03T18:42:54.3407557Z","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.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0002405"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3401397Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0010471"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3399958Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0014186"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2580756Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0831198"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2574493Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0068143"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2643074Z","Action":"RemotePreviewValueSource/RunStub","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0777113"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2572071Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"11","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0848898"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3422285Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":16,"Duration":"00:00:00.0002062"}

[MJVPBI]

Thanks All, for your replies.

I am assuming this happened to me because of limitations on the trial package for Power BI Desktop.

It may be that only one connection is allowed in this scenario.

Michael

[caracarn]

I've not tried to connect to anything new yet, but the one test I was doing is working.  Not sure that the trial package of PowerBI should not connect well to SQL.  I've not seen anything about that type of limitation.

[MJVPBI]

Agreed, neither have I .

I just thought it possible as my original connection works without flaw....

Grasping at straws....

Thanks,

Michael

[v-qiuyu-msft]

Hi @caracarn,

In your scenario, it seems the error occurred when you connected to the SQL Server from desktop, right? Were the Power BI desktop and SSMS installed on the same computer?

Please try to update the desktop to the newest version. Also enable the trace log files in Power BI desktop to see the detail error message.

Best Regards,
Qiuyun Yu

[balinaHari]

Getting error while connecting to SQL

[caracarn]

I ended up closing PowerBI just because I had no time to keep looking.  When I opened it three hours later and tried to reconnect just connected.  No idea why I was getting the error.

[v-qiuyu-msft]

Hi @caracarn,

I'm sorry the issue bother you.

It seems that the issue happened intermittently. Please use SQL Profile to trace the connection to the SQL Server, see if any useful information can be found. I guess the issue should be machine specific. You can try to install desktop in another computer to see if the same issue occurs. If possible please share detail steps with us to reproduce the issue?

Best Regards,
Qiuyun Yu

[caracarn]

I have not been able to reproduce the issue.  The detiled steps of what I did was:

1. Install PowerBI
2. Open PowerBI
3. Select Get Data
4. Select SQL Server Database
5. Enter Database Server name and Import Data and use Windows Authentication
6. Error occured

That was it.  Nothing fancy.  As I said, after trying to connect to different servers and databases the error was occuring for at least 30 minutes.  I then had to work on other tasks.  Came back to it in the afternoon and upon going in to PowerBI repeated the above steps starting at 3 and connnected immediately.  I had done the traces, but have no idea how to read them, so they were useless to me.