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. Any help is greatly appreciate. Thanks!

Need Help

5 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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