News and Announcements icon

Power Platform CommunityForums Power Apps - Power Query Troubleshooting Errors...

Power Apps - Power Query

Unanswered

Troubleshooting Errors During Refresh from API Data Source

(0) Share

Report

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!

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Artur Stepniak 1,526 Super User 2025 Season 1 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!

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Apps

#1

WarrenBelz 791 Most Valuable Professional

#2

MS.Ragavendar 410

#3

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans