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?
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.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
1,539
