cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bboy0009
Helper II
Helper II

Data refresh error:The exception was raised by the IDbCommand interface

Hi guys,

 

I struggle for understanding the problem occured on the refresh of my dataset which extract data from the EPM Anaplan. Something is strange because it have already worked and with none change it failed and it worked again

 

Here below the error message. Could you indicate me how could I find the source of the problem ? 

Capture.JPG

Thank you very much !

1 REPLY 1
ibarrau
Super User
Super User

Hi. I'm not familiarized with anaplan, but the message refers to an error for Store SQM Table. Check out the timeline of the errors. Be sure that anaplan doesn't have an action that blocks the table at the moment of the power bi refresh. If sometimes works and others doesn't you need to dig on the process involving the table. Is there any other operation with the table? is there any ETL running at the source? make sure the table is fully available when you ask for the refresh with Power bi.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

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.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors