It will perform transformations, SQL operations can be performed in power bi with query. Direct query is a direct connection to data source, data will not be stored in power bi model.
Power bi will be a visualizations layer, then query the data from data source every time(Table name, Column Name, Relationship) but not the data.
Example:- SQL SERVER, SAP HANA, AZURA SQL DATABASE, AMAZON REDSHIFT