Error on Direct Query (Live) connection after upgrade from Jan 2024 to May 2024

I have an issue on direct query connections after the upgrade to May 2024 from Jan 2024. I only have a few like this. For the time being I've updated them to an import connections. The sources are just views, so I'm not sure why the error is saying Analysis Services.

The sources are like this:

let
    Source = Sql.Database("Server_Name", "Database_Name"),
    powerbi_source = Source{[Schema="dbo",Item="View_Name"]}[Data]
in
    powerbi_source

What I've tried: 

• refreshing the connection in desktop and redeploying (works in desktop)
• changing the data source credentials on the report manager
• deploying to a test instance (same error)
• works from Power BI desktop both in May 2024 and Jan 2024

An unexpected error occurred. Please try again later.
ErrorDialogHelperText

We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.

Request ID 63e7a1a2-223a-61ee-76af-2b90359621aa

Time Mon Jul 15 2024 12:15:43 GMT+1000 (Australian Eastern Standard Time)

Service version /powerbi/libs