Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to convert clob field to string?

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello,

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

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      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.