Forum Discussion

techteam's avatar
techteam
Regular Visitor
6 years ago

Error importing "TIME" from SQL Server db

Hi, I have a problem importing data from SQL Server db. A column with type TIME(7) in db is recognised in Power BI as binary. I've tried to convert data using transform tools, without success. I'...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi techteam ,

 

You may refer to below:

= Table.TransformColumns(Source, {{"Begin Time", each Text.BetweenDelimiters(_, " ", ":", 0, 1), type text}})

 

techteam's avatar
techteam
Regular Visitor
6 years ago

Thanks v-frfei-msft for your response.

I've tried your solution, without success.

Error message:

 

Expression.Error: It is not possible to convert a value of type Binary to type Text.
Details:
Value=[Binary]
Type=[Type]