Forum Discussion
Tracing an error to a source file
Dear community,
I have connected to a folder with 18 files within.
i did some basic transformation and when i uploaded the data to the data model, PBI uploaded almost everything except 13 transactions.
Can you please help me understand how can i trace the problem and actually know what that error means?
Thank you,
Atanas
Anonymous , This is a data type error. Is it a numeric data Type column. If yes. Can you check is data in these rows have Space , - # or something else.
7 Replies
- amitchandak
Super User
Anonymous . Either in one of the tables the name has some difference, like space or special character, just make sure the header is the same.
Click on the error on at the row, level, and check what is the error. See if you can resolve it. Or share back that error too
Thank you, here's what the error says for all the 13 lines.
Do you mean some of the header name might be different in the source files? I can go and check, but just want to confirm if i understand you.
Thank you,
Atanas
I also went through each file and checked the headers. They're all the same. Not changed at all.
I tried "trim" on this column in the querry editor, but it still shows me the same error for only these 13 transactions.
Atanas
- amitchandak
Anonymous , This is a data type error. Is it a numeric data Type column. If yes. Can you check is data in these rows have Space , - # or something else.