cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GeroRenker
Level: Power Up

PQOnline Failure

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://tenantn...})], 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

1 REPLY 1
Lisabel0
Level 8

Re: PQOnline Failure