Cannot add Data source to Data gateway

[amitgawali]

Hi ,

I have recently upgraded my On-premises data gateway from version 14.16.6524.1 to 14.16.6584.1 and after that I am not able to add data source under Gateways. Hwnever I try to add Data source I get below error:

 

Can anyone tell, what is resolution of this error?

Thanks in advance!

Regards,

Amit

[v-shex-msft]

Hi @amitgawali,

Can you please provide more detailed information about this issue? It will be help to clarify your scenario.

Troubleshooting the on-premises data gateway

 

BTW, if you remove current datasource and add new datasource with correspond settings, does it works?

Regards,

Xiaoxin Sheng

[amitgawali]

If I remove current Data source and add new then also it is giving me same problem.

BTW Can you give me answer to this question also?

[v-shex-msft]

Hi @amitgawali,

Please share more detailed contents to help us clarify your issue.

For example:

Collecting logs from the gateway configurator

There are several logs you can collect for the gateway, and you should always start with the logs. The simplest way to collect logs after installing the gateway is through the user interface. In the On-premises data gateway user interface, select Diagnostics and then select the Export logslink near the bottom of the page, as shown in the following image.

Installer logs

Copy

%localappdata%\Temp\On-premises_data_gateway_*.log

Configuration logs

Copy

%localappdata%\Microsoft\On-premises Data Gateway\GatewayConfigurator*.log

On-premises data gateway service logs

Copy

C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway*.log

Event Logs

The On-premises data gateway service event logs are present under Application and Services Logs.

Fiddler Trace

Fiddler is a free tool from Telerik that monitors HTTP traffic. You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.

Refresh History

When using the gateway for scheduled refresh, Refresh History can help you see what errors have occurred, as well as provide useful data if you should need to create a support request. You can view both scheduled, as well as on demand, refreshes. Here is how you can get to the Refresh History.

1. In the Power BI navigation pane, in Datasets, select a dataset > Open Menu > Schedule Refresh.

   

2. In Settings for... > Schedule Refresh, select Refresh History.

   

   

Regards,

Xiaoxin Sheng

[amitgawali]

Here is part of GatewayXXXXXXX.log file:

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError
Reason= --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupValueException:<pi>Microsoft.Data.Mashup.MashupValueException (0x80004005): MySQL: Reading from the stream has failed.
   at Microsoft.Data.Mashup.ProviderCommon.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
   at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
   at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
   at Microsoft.Data.Mashup.MashupCommand.ExecuteReader()
   at Microsoft.Data.Mashup.DataSourceReference.TestConnection(String connectionString)
   at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.DSRTestConnectionAsync(String dsrJson, MashupCredential credential)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.MashupOleDbConnectionProvider.<TestConnectionAsync>d__3.MoveNext()</pi>

Can you help here?

[v-shex-msft]

Hi @amitgawali,

I can only find your log alert :

MySQL: Reading from the stream has failed

I think you need to check on this part or share more detail logs.

Regards,

Xioxin SHeng