cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Paginated Report couldn't be export trough API

Hi, 

I have a paginated report connect in direct query to my SQL Server DB and to a Power BI Dataset.

In the Power BI interface (website) all works fine. I can view my report and I can export it in all available format but when I want to export it trough the Power BI API, I received this error message : 

{

   "title": "Precondition Failed",

   "status": 412,

   "detail": "BUSINESS ERROR : Connection Error NotOpen: Connection open intermittent error while reading in Analysis Services, needs retry."

}

 

What does it mean ?

Why is there a connection to Analysis Services ? Does it related to the Dataset ?

 

FYI : 

We are using Power BI Premium with embeded capacities.

There a lots of other paginated reports in the same workspace (but none with a dataset connection) and it works perfectly (so no rights problem.

1 REPLY 1
fvalencia
Frequent Visitor

Were you able to resolve this issue? I'm having the same problem.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.