Edit Oracle Query is Greyed Out in Power BI Desktop

[mnburke]

Hello,

Does anybody know why I wouldn't be able to edit my oracle query? I have one table in my data model that I wish to slightly tweak, but upon going to 'Transform Data' > 'Change Source' as i've done in the past, the code itself is now greyed out, so I cannot access it to make the edit to the SQL code. I'm not sure what has changed; any help here is appreciated. Thanks!

[selimovd · Accepted solution]

Hey @mnburke ,

I know it's a little confusing, but you cannot access the query in the data source settings.

Go to Power Query and click on the small gear icon in your query:

In the upcoming dialogue you can change the query:

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi

[mnburke]

This did the trick, thanks a lot Denis!