Newbie question - no Transform button

[ruserty]

Hello! Started exploring Power BI in order to put all the company's data here in Moscow.

I dont have Transform button in my Power BI, so I cannot remove duplicates, split coloumns etc.

Can you help please, how do I add?

[MFelix · Accepted solution]

Hi @ruserty,

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)

Regards,

MFelix

[ruserty]

Thank you very much, MFelix!

[Quashini]

Hi @MFelix ,

Would you know the cause why the "Load" and "Transform Data" button is missing in the Navigator window? Can't seem to access those buttons after I clicked Get Data option (see image below).

Please advise. Thanks!

[MFelix]

Hi @Quashini ,

You need to check the box on the left side of the sheet name, when selecting the name as you have you are only making a preview of the data.

Regards,

MFelix