Not able to See transform data option

Hi AnushaR,

You are previewing the data hence no transform data. You could create on create and it should bring you to power query editor

Try creating the table in Power BI, then click transform data in the ribbon and see if you can update the PowerQuery source expression for the table.

Assuming you are not using a legacy connector 

Hi AnushaR  I think this is in preview mode you could go to transform data and click on the data set and then edit that this will go to power query to edit