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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Anonymous
Not applicable

Connection open intermittent error while reading in Analysis Services

Searching the forums I see several posts for this error, but no solutions, so posting my version of the issue, hopefully I can get a solution.

 

Attempting to download a Power BI paginated report to a .CSV file, using "connect-powerbiserviceaccount" to connect to Azure, and then using "Invoke-RestMethod" to pass in the request for an export.

 

The export request is successful, and I can query the export ID and see the status change from "notstarted" to "running", but then it always fails:

 

status : Failed
error : @{code=Connection_Error_NotOpen; message=RootActivityId(<GUID>)
Connection open intermittent error while reading in Analysis Services, needs retry.;
details=System.Object[]}

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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