Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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
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.
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.
Hi @MichaelTH ,
Can you please try to explicitly define schema mapping?
Let me know if you are still facing the issue.
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 .
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 .
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
2 |