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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
emilyannnmay12
Frequent Visitor

Invalid Cursor State Error

I am using Power BI desktop and i get an error everytime I refresh one of my queries. The error is "Unable to connect: IBM DB2:ERROR [24000] [ibm] CLI0115E Invalid cursor state. SQLSTATE = 24000"

2 REPLIES 2
emilyannnmay12
Frequent Visitor

I get the same error everytime I try to refresh my data set in the desktop version. The error says "Unable to Connect. Details IBM DB2 ERROR [24000] [IBM] CLI0115E Invalid cursor state. SQLSTATE = 24000"

v-yuta-msft
Community Support
Community Support

Hi emilyannnmay12,

 

It seems like there's something wrong with the cursor state when you implement your sql statement. So the error is more about the SQL statement. In addtion, please check if there's same error when you implememt the same script in your database. 

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.