Troubleshooting Errors During Refresh from API Data Source

(0) Share

Report

Posted on by WA-19122138-0

Using Power BI Desktop

When refreshing a large amount of data using an API data source (with my GetApptPages() function), I randomly get the generic ODBC error: Failed the decryption step. See inner exception. When I attempt to introspect the 'inner exception' I don't see an error message. When I click on the Error cell, I get a table structure that contains all the data for that PageNo (see below). When I test the GetApptPages() function for PageNo 295, I get no error.

How can I get to the root cause of these Error rows in my Power Query?

HELP!

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Artur Stepniak 1,528 Super User 2025 Season 2 on at

Like (0)

Report

Troubleshooting Errors During Refresh from API Data Source

Hello,

what's the datasource that you're using? Can you check the logs from this side? The randomness of the error suggests that it could be related to the database itself - throttling mechanism maybe? You'd need to check it.

In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.

Best regards,

Artur Stepniak

Interested in GenAI? Visit my site!

Was this reply helpful? Yes No