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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

PQOnline Failure

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I have an OData query what i try to load to a custom entity, and always getting back this error message:

Load to Common Data Service failed. Details: [(PQOnline failure - The powerquery job failed with error: Challenge ChallengeType:Resource, ChallengeDataSource:{"Kind":"OData","Path":"https://tenantname.sharepoint.com/sites/pwa/_api/web/contenttypes","NormalizedPath":"https://tenantname.sharepoint.com/sites/pwa/_api/web/contenttypes","IsDefaultForKind":false})], One or more errors occurred.. (Job ID: 923afede-6842-4816-8c7c-2e9ed7b3de8b)

 

My query is the following:

let
Source = OData.Feed("https://tenantname.sharepoint.com/sites/pwa/_api/web/contenttypes", null, [Implementation="2.0"]),
#"Removed Other Columns" = Table.SelectColumns(Source,{"Description", "Hidden", "Name", "StringId"}),
#"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"StringId", type text}, {"Name", type text}, {"Description", type text}})
in
#"Changed Type"

 

i am trying to load only 4 fields, and tried nearly everything, and still not working.

Anyone has any idea, what would be the problem?

Obviously the query is working in Power BI and Excel

I have the same question (0)
  • Lisabel0 Profile Picture
    154 on at
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I have the same error message. Was working fine for some weeks, and suddenly this week it stopped updating... 

  • Vinoths Profile Picture
    6 on at

    Hi,

    I have the same error when i join the Sales entity and Finops entity using merge queries in powerquery editor.Did you get resolved it?

     

     

    Thanks

    Vinoth SUSAINATHAN

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard