unable to convert an m query in table 'PRLINE' into a native souce query in power bi

[Raghu_1753]

While I am adding fields to Table visual it's showing me an error like "unable to convert an m query in table 'PRLINE' into a native souce query in power bi". I have queiried to oracle db and brought up a new table and when i'm trying to add those fields to Table Visual I am getting this error. Can anyone pls help me?

I'm in a Direct Query connection.

[amitchandak]

@Raghu_1753 , Are you writing a query into the advance option, if yes, there seems to be some issue.

or share first few lines of power query code

[Raghu_1753]

select f.failureremarkid,f.wonum,f.issueclosedate,f.siteid,f.description,regexp_replace(dbms_lob.substr(ldtext, 2000, 1 ), '<.*?>') as Workorder_longdescription,l.ldkey,
l.ldownertable from maximo.failureremark f LEFT OUTER JOIN
maximo.longdescription l on f.failureremarkid = l.ldkey
where ldownertable = 'FAILUREREMARK'

[Raghu_1753]

@amitchandak  I have provided the query which I used in Advanced option. Will you pls check and provide you comments.