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...

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?

You say it runs in seconds when run 'directly'. So presumably you are running it 'indirectly' – can you elaborate on that?

This sounds like the best idea, though obviously it will take some time to...

Yes, I saw that as well, but how are the sources different? The OP didn't...

The sources for the datasets are different, so I don't think that will work.