Skip to main content

Notifications

Power Apps - Power Query
Unanswered

Troubleshooting Errors During Refresh from API Data Source

(0) ShareShare
ReportReport
Posted on by
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!

Under review

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.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,867

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,174

Leaderboard

Featured topics