Forum Discussion
Change the source data for a data model
I have a data model generated with get&transform, data are 6 excel files in a folder. i have set up a range of pivot tables based on the (3 tables) model. On another worksheet I have tables that loo...
All it should take is click the cog wheel in the first step of the queries that pull in the data?
JKPieterse
I wish.... did not work for me, I pointed to the new location, but there was no effect on the data. Also, as I said, the data needs some cleaning up during import. The fact that the original data are 6 files to be combined and the new data is only 1 file might complicate things.