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 you help please, how do I add?

 

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

     

     

4 Replies

  • 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

     

     

      • 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!