Models fail to refresh and take longer

[sgallo]

Hi,

Over the last few weeks I have noticed a deterioration in the model refresh performance.

Today, I noticed that all my models have failed to refresh after many hours of loading.

Not sure if anyone is experiencing anything similar.

I have tried with old gateways and new ones. Also trying on desketop but the connection times out after a bit and it fails to refresh.

Any help is appreciated

[sgallo]

I am getting the following error in Power BI when refreshing a model: Data source error: {"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":"Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"11"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"gails-sql-pool.database.windows.net;gails-reporting-new-model"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: DimDepartments

Where the table at the end, keeps changing as it was DimTime and FactSales in other refresh

[Jonvoge]

Hi sgallo

Can you provide additional information about your capacity setup?

Are you on a Premium Capacity? And if you are, are you monitoring the activities of the capacity?

If you are on a Premium Capacity, and you observe poor performance, it could be because other content on your capacity is eating up all other available resources.

If you are not on a Premium Capacity, but are instead on a Shared Capacity, it is not uncommon to see performance fluctiations, however it would be odd to see a sudden increase of many hours as you seem to experience.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[sgallo · Accepted solution]

I am Premium user. I am not experiencing capacity issues from what I can see as some models that usually would take a few minutes, are now failing after one hour or refreshing.

Moreover, I tried to publish the simpler models in another workspace and see if it improves but with little to no luck so far.

Not sure if there is anything else I could try that i am missing