Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
ruserty
Regular Visitor

Newbie question - no Transform button

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?

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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)

 

Transform-.png

 

Regards,

MFelix

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

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)

 

Transform-.png

 

Regards,

MFelix

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thank you very much, MFelix!

Anonymous
Not applicable

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!

 

Untitled.png

 

Hi @Anonymous ,

 

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors