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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
srpeters
Helper II
Helper II

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 is that we have middleware from a third-party company that is using their own data types. One of these data types is not recognized and is causing the replication to break with an "Illegal characters in path" error message. The datatype is a 'UserDefinedDatatype'. Without breaking everything that is using this middlewares' data type, is there anything we can do to resolve this so that we can replicate from that first SQL database to our Power Bi SQL database? Could we convert the type to one that SQL recognizes when replicating without changing the original database? 
 
Any suggestions are appreciated, thank you in advance. 

1 ACCEPTED SOLUTION

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.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.