Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

view native query disabled for oracle source

I am using oracle as source, why is view native query disabled ? I thought for all the sql sources it should be enabled.
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    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's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

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.