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!