Forum Discussion

mlane's avatar
mlane
Icon for Helper I rankHelper I
11 months ago
Solved

How can I know the timeout settings or retry settings allowed for semantic model on my server?

  So I can tell from the refresh history that I have about 5 datasources that were set to have timeout and retry attempts.    It looks like it retries about 4 times.   How can I tell the number of r...
RestAPI
  • v-venuppu's avatar
    v-venuppu
    10 months ago

    Hi mlane ,

     Yes, that document link is correct for rsreportserver.config.

     DatabaseQueryTimeout - applies only to the ReportServer DB itself, not your dataset queries.

     ProcessTimeout - controls worker process lifetime, not dataset queries.

     ScheduledRefreshTimeoutMinutes - the key setting for dataset refresh duration (default 120 minutes).

     Retries (4) - hardcoded in PBIRS/SSRS for dataset refresh, not configurable anywhere. The only configurable retry is for subscription delivery (default 3).

     In short, you can adjust timeout values (via SSMS or rsreportserver.config), but retry attempts for refresh are fixed and cannot be changed.

    Thank you.

v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
11 months ago

Hi mlane ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you tayloramy for the prompt response.

Timeouts - These are set at the data source or dataset level. You can check or adjust them in SSMS (Reporting Services instance) or in the rsreportserver.config file. If not set, the default is usually 120 seconds.

Retries - The 4 retry attempts you see in refresh history are hardcoded by PBIRS/SSRS for transient failures. They are not configurable anywhere.

So,you can view/change timeout in SSMS or config.Retry count cannot be changed - it’s built into the engine.

 

mlane's avatar
mlane
Icon for Helper I rankHelper I
11 months ago

tayloramy and v-venuppu 
   I have a few follow up questions.  .  I suspect strongly that I am connected to a single database node Reporting Server Database (connected to SSRS) for a multi-database SQL Server Network.   I have some admin access to the PowerBI, but nothing to the sql server  However, I will need to confirm this.  For say of discussion the entire SQL Server Network is called CAD and the specific database node I connect to is RDW1CAD
I have additional more critical follow up questions about the Power BI Side.  But to not confuse my team I need seperate the conversation. 

First my questions about the dataset level RDW1CAD.   

  1. I am going to ask them to pull me the values from the file.   If an administrator pulled the rsreportserver.config ... Is this the documentation for the file you are talking about? https://learn.microsoft.com/en-us/sql/reporting-services/report-server/rsreportserver-config-configuration-file?view=sql-server-ver17 
  2. Is the the parameter DatabaseQueryTimeout?  If so, does the parameter ProcessTimeout apply to Power BI to queries (given read only queries that can write to temp, use sql functions, and use sql stored procedures)?
  3. Where is the hardcoded setting for retries in SSRS or my database?  I need to confirm if its really 4 or not set. Is it in the registry?  A different config file?   The only setting for tries I can see in the documenation says the default is 3 (an that is for the Delivery extension)