The following M query references the SQL view (BI.vDim_Customer) via the staging query (AdWorksSQLServer) and does not apply any further transformations:

The customer query accesses the unique M record associated with the schema (BI) and SQL view (vDim_Customer) from the table produced by the staging query (AdWorksSQLServer). This record contains all field names of the staging table query including the Data field that stores the SQL view. Referencing the Data field of the M record retrieves the results of the SQL view. 

Since no M transformations are applied, the M query reflects the source SQL view and changes to the SQL view such that the removal of a column will be automatically carried over to the Power BI dataset upon the next refresh. The one-to-one relationship between the SQL view and the M query is one of the primary reasons to favor implementing, or migrating, data transformation logic within the data warehouse source rather than in the Power BI dataset.