Forum Discussion
How do I edit an existing Query on an Excel file?
I have an Excel file as my data source. The first time I connected, I transformed quite a few columns.
I have made edits to the Excel file and need to reload it and create new transformations.
From Power BI Desktop, I do not see an option to edit an existing query/transformation. Only create new.
Using Desktop Version: 2.81.5831.821 64-bit (May 2020)
Hi noconnor ,
You could edit queries from applied steps. Click the little gear and edit the query.
You could also open advanced editor to edit the query. But you don't have any query here, so it is grayed out.
2 Replies
Hi noconnor
If you saved them, you should be able to see your queries right there. You seem to have no queries in that file.
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi noconnor ,
You could edit queries from applied steps. Click the little gear and edit the query.
You could also open advanced editor to edit the query. But you don't have any query here, so it is grayed out.
