Forum Discussion
Cant access my direct query code
I set up a data source using direct querry but now I can't seem to go back and edit it. The querry still runs but I need to edit it and for some reason the source does not have the setting "gear" ico...
hi Anonymous
When you use parameters in the SQL query, the gear icon don't show the query.
You need to edit it in Advanced Editor
https://docs.microsoft.com/en-us/power-bi/desktop-query-overview#the-advanced-editor
Regards,
Lin
v-lili6-msft
Community Support
Community Supporthi Anonymous
When you use parameters in the SQL query, the gear icon don't show the query.
You need to edit it in Advanced Editor
https://docs.microsoft.com/en-us/power-bi/desktop-query-overview#the-advanced-editor
Regards,
Lin
Thanks, yes I am using parameters but I was hoping to be able to avoid the advanced editor, although I guess its not that big of an issue.
Either way, thanks a lot