Solved: How do I edit an existing Query on an Excel file?

noconnor · ‎06-02-2020

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)

v-eachen-msft · ‎06-03-2020

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.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

v-eachen-msft · ‎06-03-2020

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.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

AlB · ‎06-02-2020

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

How do I edit an existing Query on an Excel file?