Forum Discussion

JanRambo's avatar
JanRambo
Regular Visitor
8 years ago
Solved

MS SQL server timeout

Hello PBI team,   we have following scenario:   a) On-Premise Data Gateway is installed on an app server, b) MS SQL as a source data is geographically elsewhere, c) 3 reports published on PBI s...
Need Help
  • JanRambo's avatar
    JanRambo
    8 years ago

    Hi,

     

    we have checked on the SQL server timeout and it set far beoynd our timeout error. We have one more time republished all reports and manually set timeout to 120min prior to publishing to PBI service and it worked. Very strangely, now data sets are refreshed normally without hitting original timeout period of around 55 mins.

     

    I just hope this will be stable now :)

     

    Thanks for help!

     

    Jan

dung-anh's avatar
dung-anh
Advocate I
8 years ago

Hi JanRambo

 

How do you:

1/check the SQL Server timeout?

2/ and set manually set timeout of the report to 120min prior to publishing to PBI service?

 

Thanks in advance,

Dung Anh

JanRambo's avatar
JanRambo
Regular Visitor
8 years ago

Hi Dung Anh,

 

we have an internal team supporting our SQL server, so I can not help with that, sorry.

 

ad 2/ You need to edit each query settings, before publishing to PBI service.

  • DAN's avatar
    DAN
    Advocate II
    8 years ago
    Thanks a lot JanRambo!

    Dung Anh