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 Platform Community / Forums / Power Apps / Problem "Get Data" in ...
Power Apps
Unanswered

Problem "Get Data" in CDS 2.0 not working

(1) ShareShare
ReportReport
Posted on by 515

I try Get Data for a basic custom entity with 4 text columns, the wizard works perfectly until the start of importing then i get this error: -

 

Any idea?

 

Load to Common Data Service failed. Details: An error occurred while validating input parameters: Microsoft.OData.ODataException: Does not support untyped value in non-open type.
at System.Web.OData.Formatter.Deserialization.DeserializationHelpers.ApplyProperty(ODataProperty property, IEdmStructuredTypeReference resourceType, Object resource, ODataDeserializerProvider deserializerProvider, ODataDeserializerContext readContext)
at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.ApplyStructuralProperties(Object resource, ODataResourceWrapper resourceWrapper, IEdmStructuredTypeReference structuredType, ODataDeserializerContext readContext)
at Microsoft.Crm.Extensibility.OData.CrmODataEntityDeserializer.ApplyStructuralProperties(Object resource, ODataResourceWrapper resourceWrapper, IEdmStructuredTypeReference structuredType, ODataDeserializerContext readContext)
at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.ReadResource(ODataResourceWrapper resourceWrapper, IEdmStructuredTypeReference structuredType, ODataDeserializerContext readContext)
at System.Web.OData.Formatter.ODataMediaTypeFormatter.ReadFromStream(Type type, Stream readStream, HttpContent content, IFormatterLogger formatterLogger). (Job ID: 2c206076-6994-4546-8d1e-a1d22ad86672)

I have the same question (0)
  • CWesener Profile Picture
    Microsoft Employee on at

    Adding @millopis from the Power Query team.

  • Yahya Manasrah Profile Picture
    515 on at

    Hi @CWesener and @millopis, and that's for always being available.

     

    I found a resolution that I would like to share, although I don't think this error should exist but here is the reason and how to eliminate.

     

    The reason of this error is that if I create an entity and name as COUNTRY, Name of the primary field cannot be also called COUNTRY. Simple.

     

    If I call the primary field anything else, such as COUNTRY NAME, then power query works perfectly.

     

     

    Thanks.

  • AngeloMollame Profile Picture
    Microsoft Employee on at

    Hello Yahya.

    Thanks for reporting this. We will introduce an additional validation rule that indicates that it's not possible to create an entity if it has a field with the same name as the entity itself.

     

    Thanks

    Angelo

  • Apostolis Profile Picture
    Microsoft Employee on at

    Confirmed issue & fix works, thanks Yahya 

  • Smitha10 Profile Picture
    5 on at

    I am getting the same error with a different Primary name vs the entity name.  I am training in powerapps and an admitted newbie but I have followed the instructions but I am unable to imort my data.FieldmappingError1.pngDataError1.pngEntity error1.pngError1.png

    DataError1.png
    Error1.png
    Entity error1.png
  • Kyle M Garrett Profile Picture
    7 on at

    I have the exact same issue.

    I am also training and taking the same course via EDX.org.

  • dazhang Profile Picture
    Microsoft Employee on at

    @KyleGarrettand @Smitha10: sorry for the late reply. Would you mind starting a new thread for this issue, as it's unrelated to the issue that the current thread was created for?

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