Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
MichaelTH
Frequent Visitor

How to fix mapping error involving null value from rest api source

I am using a rest api to copy data into a data warehouse through data pipeline. There is a column from source containing null value. When mapping, the source column sets as string type to destination column string type.

 

When I try to run the pipeline, the copy data activity throws error: "UserErrorSchemaMappingCannotInferdestinationColumnType: ErrorCode=UserErrorSchemaMappingCannotInferdestinationColumnType,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Data type of column 'property_street2' can't be inferred from 1st row of data, please specify its data type in mappings of copy activity or structure of data.,Source=Microsoft.DataTransfer.Common,"

 

How should this error to be fixed?

 

Thanks.

4 REPLIES 4
Anonymous
Not applicable

Hi @MichaelTH ,

We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.

Anonymous
Not applicable

Hi @MichaelTH ,

Can you please try to explicitly define schema mapping?
Let me know if you are still facing the issue.

Anonymous
Not applicable

Hello @MichaelTH ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help .

Anonymous
Not applicable

Hello @MichaelTH ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help .

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.