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

[aduguid]

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

[v-jianpeng-msft · Accepted solution]

Hi, @aduguid 

This issue does exist in the current version and you can roll back your version to January:

Also you can refer to the following case of the same problem where an effective solution is provided.

Solved: Couldn't connect to analysis service After Report ... - Microsoft Fabric Community

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.