How to convert clob field to string?

[Anonymous]

Hello, we are using Life connection to PBI desktop. I need to take part of the string from the clob field. Oracle query is using dbms_lob.substr. Couldn't find any solutions of how to accomplish that. Any help is greatly appreciate. Thanks!

[Anonymous]

Thanks, Is anyway i can convert clob to string via power bi?

[lbendlin]

Only with Power Query, not with DAX.

[lbendlin]

Live connection? To where?  Or did you mean Direct Query?

[Anonymous]

Hello,

Thanks for the quick respond! on the bottom of my report - Connected Life to the Power bi dataset, thanks

[lbendlin]

So you are live connecting to a Power BI Semantic Model which in turn connects to an Oracle data source which includes a clob field?

In that  case the Power Query of that Semantic model needs to transform the clob field into a data type that is understood by Power BI.

DAX Data types – DAX Guide

Note that "Binary"  is not something DAX actually understands.