web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Query / Troubleshooting Errors...
Power Apps - Power Query
Unanswered

Troubleshooting Errors During Refresh from API Data Source

(0) ShareShare
ReportReport
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)
  • Suggested answer
    Artur Stepniak Profile Picture
    Artur Stepniak 1,528 Super User 2025 Season 2 on at
    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!

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

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans