Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • fvalencia's avatar
    fvalencia
    Frequent Visitor

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