Forum Discussion
Solved
Middleware datatype unrecognized when replicating SQL tables
Hello, The data for my reports are coming from a secondary SQL database. We are replicating a portion of a much larger database to this secondary one for these reports. The issue we have run into ...
You could consider using a view at the source to convert it into a more standard type, or to consume it in Power BI as binary, then convert to text, and then parse as needed.
What is the content? Binary, plain text, JSON, XML, EDI?
lbendlin As far as I am aware it is a SQL user defined date field, so I am assuming its plain text in a dd/mm/yyyy format. The original SQL table has entries for this datatype but the issue is when we are trying to replicate it to a different server.
You could consider using a view at the source to convert it into a more standard type, or to consume it in Power BI as binary, then convert to text, and then parse as needed.
