view native query disabled for oracle source

[Anonymous]

I am using oracle as source, why is view native query disabled ? I thought for all the sql sources it should be enabled.

[v-janeyg-msft]

@Anonymous  Any updates?

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

Are you adding a SQL statement to the box below? If so, that is why.

You can refer to this document to understand why:

Solved: View Native Query always disabled - Microsoft Power BI Community

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[bcdobbs]

I've not used an oracle connector however if you step back through the power query steps does it let you view native query for anything earlier on? Wondering if something you're doing is breaking query folding.