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

[mlane]

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 retry attempts a datasource has on my server?  Or the current time out value? 

I am just not sure where those settings might be.  

[tayloramy]

Hi @mlane, 

Do you have permissions to remote into the server hosting PBIRS? 

If so, you can connect to the reporting services in SSMS and see all the settings in there. 

If you don't have access you will need to work with your IT team that does have access to be able to get this info. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.   

[mlane]

Thanks for your reply!  I am going to merge the discussion to what venpuu was saying.
I am some permission to pull data from the remote server and I work with the person who has direct access.  I need to know what settings I am looking for in the power bi gateway and its configuration file. 

[tayloramy]

Hi @mlane, 

Once connected to the report server in SSMS, go to server properties -> advanced: 
under other there is sessionTimeout: 

 and then under user-defined are a lot more timeouts like: 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.   

[v-venuppu]

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]

@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-configu... 
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)

[v-venuppu]

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]

Hi @mlane ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[v-venuppu]

Hi @mlane ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.