Forum Discussion
dengydongn
Microsoft Employee
Microsoft EmployeeHow to avoid importing the same table again and again
Hello all, I have this Spark SQL table as data input, and based on it I need to draw multiple charts, each chart requires different processing on the data (filtering, grouping, etc..), so for eac...
samdthompson
Memorable Member
Memorable MemberHello, import once then in power query reference the table (right click on the query and reference) many times each with their own transformations applied. That way the Spark SQL is only hit once but you have all the variations you want.
dengydongnMicrosoft Employee
Microsoft EmployeeThanks, this looks great. A further question, since I already have multiple queries each individually imports the same data source then applied various transformation, now I'm able to reference a data source, is there a way I can easily move one query from one source to another source (reference), or can I move steps applied on one source to another (reference), basically I'm trying to avoid manally creating all the steps on the reference source. Thanks