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

aduguid — Mon, 15 Jul 2024 04:14:45 GMT

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

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

Anonymous — Tue, 16 Jul 2024 08:17:07 GMT

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.

topic Error on Direct Query (Live) connection after upgrade from Jan 2024 to May 2024 in Report Server

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

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