Forum Discussion

ruserty's avatar
ruserty
Regular Visitor
9 years ago
Solved

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 yo...
Need Help
Tutorial Requests
  • MFelix's avatar
    MFelix
    9 years ago

    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

     

     

MFelix's avatar
MFelix
Super User
9 years ago

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's avatar
    ruserty
    Regular Visitor
    9 years ago

    Thank you very much, MFelix!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        MFelix
        Super User
        6 years ago

        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