No transform button

[Anonymous]

Hi there, 

I am trying to learn how to use PowerQuery, when I upload data from a CSV file it loads it on to excel, but only gives me the option to load and not the option to transform the data. I am seriously confused about what to do about this. 

[v-yalanwu-msft]

Hi, @Anonymous ;

The Transform option is in the Advance query editor you need to choose the Edit Queries and then you have the Transformation tab, the query editor is also acessible when you make the link to a new data source it allows you to edit the query (except for SSAS models)

Query overview in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tackytechtom · Accepted solution]

Hi @Anonymous ,

Is this button greyed out on your end?

Alternatively, you can also transform the data by clicking onto Get Data > Launch Power Query Editor:

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/