Forum Discussion
Edit Oracle Query is Greyed Out in Power BI Desktop
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!
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
2 Replies
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.biThis did the trick, thanks a lot Denis!
