Can you somehow modify the process to make it incremental, or are all the rows always new?

If you have space, perhaps you could try running the insert to a staging...

That's a requirement, not a question.

Why don't you start by presenting what you have tried so far, along with your findings?

This does not...

WITH ordered
AS (SELECT UNIT
          ,ORDER_DATE
          ,rn1 = ROW_NUMBER ()...

Assuming you're trying to move away from a self-hosted model, there is a halfway house. We have found that Azure DBs (ie, DB as a service) are extremely expensive if...

Is this a blog post, or are you hoping for a response?

What is your question?

A SSAS model is called a Semantic Model in Azure:

https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand

Did you do any research before posting your questions?

https://learn.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-ver16

Hi we know (or believe)  ssas saas gets stood up separately when a company migrates to sql saas.

But what happens to ssis and ssrs?  from what i remember there...

OK, I'm done. Please post back with details when you manage to resolve this – it may help others in future.

I am running out of ideas.

As this happens for only one query, there must be something about that query which is different from all the others. Is there anything special...

And are you using prepared statements?

https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.prepare?view=net-9.0-pp

Does the query contain variables or parameters?

OK, understood. Is this a fundamental connection problem (ie, all queries time out), or is there just one particular query which is giving the issue?