Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.