Hi Ken,
I am working on one project which require same data source but cut slightly 4 to 5 times.
I have started use Power Query now and know that I can create connection to source data from Power Query and then link it to Power Pivot.
My question is now that is it possible to wash and transform data inside only one Power Query (with diff. steps) and some of those steps from Power Query link to 5 tables in Power Pivot table.
so when I refresh Power Query it refresh only once and update 5 to 6 tables inside Power Pivot.
I have done it already with 5 seperate Power Queries but when I am trying to refresh data it refresh 5 time.
Thanks.
Harry
I am working on one project which require same data source but cut slightly 4 to 5 times.
I have started use Power Query now and know that I can create connection to source data from Power Query and then link it to Power Pivot.
My question is now that is it possible to wash and transform data inside only one Power Query (with diff. steps) and some of those steps from Power Query link to 5 tables in Power Pivot table.
so when I refresh Power Query it refresh only once and update 5 to 6 tables inside Power Pivot.
I have done it already with 5 seperate Power Queries but when I am trying to refresh data it refresh 5 time.
Thanks.
Harry