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
