The problem with the scheduled update data through the gateway

[Timofeev]

Hello

I have 3 reports with the same data sources, which are updated through the data gateway.

2 reports are updated normally.

One report invariably returns an error.

Error code:
{"error": {"code": "DM_GWPipeline_Gateway_RuntimeCheckFailedError", "pbi.error" {"code": "DM_GWPipeline_Gateway_RuntimeCheckFailedError", "parameters": {}, "details": []}}} Table: name_table.

I understand that swears on the table name_table. But I don’t understand what is wrong with her.

I did not find this error on the forum or similar errors from someone via google. I would be grateful for the help / advice.

[RODRIGO_teixeir]

@Timofeev 

you found a solution, am i having the same problem?

[v-alq-msft]

Hi, @Timofeev 

I have some questions.

1. Which data source are you using?

2. Are you using a enterprise gateway or a personal gateway?

3. Are the data source definition created in 'Manage gateway' mapped to all three datasets?

I'd like to suggest you update the gateway to the latest version and use Fiddler to troubleshot the scenario. 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 traffic list might show errors and other related information.

For further information, you may refer to Troubleshoot gateways - Power BI and Troubleshooting refresh scenarios .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Timofeev]

Hi 1. Postgres SQL 2. Personal 3. Gateway of the latest version. I downloaded and installed 3 days ago. Fiddler - I'll see. thank

[collinq]

Hi @Timofeev ,

I am wondering if the issue is actually the timeout.  I would increase the Command and Connection TimeOut variables.  I believe the default is 10 minutes.  Maybe something like 60 or 90 minutes instead of 10.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[RODRIGO_teixeir]

@collinq , 

how to increase the Command and Connection Timeout variables? I have the same problem and would like to do this test.

thankful.

[Timofeev]

Increased to 90 minutes in changing the request to postgres sql. It did not help, the problem remained.

[Timofeev]

Hi

Thanks, I'll try.