Connection open intermittent error while reading in Analysis Services, needs retry.

[htech_ziad]

Hello,

I have developed a web application using .NET Core as the backend and Angular as the frontend. I have successfully embedded normal reports using the Power BI service. However, I am facing an issue when trying to embed paginated reports. The error message I received reads: "Connection open intermittent error while reading in Analysis Services, needs retry."

Additionally, when I tried to embed an empty paginated report, I received the error message: "One or more errors occurred while converting CSDL to a conceptual schema."

It is worth noting that the token generation method works fine, and the token is returned to the frontend. The issue only arises when attempting to render the report. I am using the "powerbi-client-angular" library in Angular for embedding the Power BI report.

Do you have any advice on how to resolve this issue?
Thank you.

[htech_ziad · Accepted solution]

Apologies for the delay in checking the post. I have resolved the issue by deleting the report's data source and creating a new one. You can achieve this by duplicating the report and then publishing it again. I hope this information is helpful to you.

[YcPeh]

Hi @htech_ziad , do you mean by first click on the paginated report in Power BI Service > click "Edit in Report Builder" > delete the current semantic model connection > right click on "Data Sources" > click "Add Power BI semantic model connection"? 

[asbpowerbi]

We are running into this issue as well. The paginated report shows up fine when displaying the report in the PowerBI service. However when we embed it, we get the error. Any debug suggestions?

Cheers!

[RcDevs]

@htech_ziad Having the same issue...did you find a solution? Appreciate any help.

[Anonymous]

@htech_ziad , having the same issue, any solutions??