VIEW COMMENTS THAT ARE STORED AS LONG IN AN ORACLE DATABASE

[MONA4980]

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 of LONG and a lenght of 0. is this like a blob?

Anyway how do I convert that column into Power BI to be able to view the results in my new query? 

[v-kathullac]

Hi @MONA4980 ,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,

Chaithanya

[Akash_Varuna · Accepted solution]

@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]

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