I cannot refresh report in Power BI services because I'm getting constantly timeout refresh error. However until previous week it worked without any problems. I have some source tables from ODBC connector, some excel files and also I have plenty of "reference tables" that append and modify these source tables. I've change CommantTimeout and ConnectionTimeout in all my ODBC source tables to 4 hours,
"let
Source = Odbc.DataSource("dsn=xxxxxx, [HierarchicalNavigation=true, CommandTimeout=#duration(0,4,0,0), ConnectionTimeout=#duration(0,4,0,0)]),"
yet precisely after 2 hours my report will stop refreshing and throw this timeout error, each time on a different table though:
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Timeout expired. The timeout period elapsed prior to completion of the operation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.HostingError.Reason","detail":{"type":1,"value":"Timeout"}}],"exceptionCulprit":1}}} Table:
I didn't see anything helpful in similar conversations so I need help please.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Pocahontas
Can you refresh report in PBI Desktop ? Has a large amount of data been added to the data source recently, causing a refresh timeout ? You mentioned that you have change CommantTimeout and ConnectionTimeout in all my ODBC source tables to 4 hours , but in Shared capacity , the refresh time should not exceed 2 hours.
You can use the following link to troubleshoot your problem .
Troubleshoot refresh scenarios - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Ailsa Tao