Hello,
I have been working with the SQL Server connector to manipulate some table data using the Transform Data Using Power Query action. I have merged and filtered 4 tables to achieve the final single table output I need.
From here I would like to output the completed final table to an excel worksheet and email on a weekly basis. When I select the "create Excel worksheet" connector, I'm a little lost as to how to find the entire table output to insert as an email attachment. I am shown the out put of each column from my new table but the entire finished table.
Any help would be greatly appreciated.
Rgds,
Rob