Forum Discussion

MONA4980's avatar
MONA4980
Frequent Visitor
1 year ago
Solved

VIEW COMMENTS THAT ARE STORED AS LONG IN AN ORACLE DATABASE

Needing some help. When I get new source, from an oracle database, and select the table I want it is not showing the data for the results column. I searched that table structure and it is a data type...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    MONA4980 To view a LONG column in Power BI, you can create an Oracle view that casts the column to a CLOB or VARCHAR2. Alternatively, use the TO_LOB function in your query to convert the LONG data. Ensure you use the OLE DB or ODBC connector for better handling of LONG data types. Another option is extracting and converting the data in SQL Server before importing to Power BI.

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

MONA4980 To view a LONG column in Power BI, you can create an Oracle view that casts the column to a CLOB or VARCHAR2. Alternatively, use the TO_LOB function in your query to convert the LONG data. Ensure you use the OLE DB or ODBC connector for better handling of LONG data types. Another option is extracting and converting the data in SQL Server before importing to Power BI.

  • MONA4980's avatar
    MONA4980
    Frequent Visitor
    1 year ago

    Hello Akash,

    I have oracle sql editor and I tried cast(comments as varchar2 (100)) and it says it is incompatible data type. So after I get that into Power BI as a long data type how would I do a to_lob? I do not have full rights to create a view in the Oracle database so I will have to do something within Power BI to make it work. Sorry for the questions but I am very very green to PowerBI and learning on the fly