Hi guys,
I've merged 6 excel files and created a data model and added it as a connection. I've created many pivots with this connection. Now when I make a change in this merged excel file and click on refresh (which is also this data model's workbook) it deletes all the changes.
If I right click on this data model and choose edit, it creates a new query but my pivots are connected with the first one. Shortly, I dont know how to update and make some changes in my query. By the way, I want to add and delete some columns.
Can you please help?
Thank you in advance.
I've merged 6 excel files and created a data model and added it as a connection. I've created many pivots with this connection. Now when I make a change in this merged excel file and click on refresh (which is also this data model's workbook) it deletes all the changes.
If I right click on this data model and choose edit, it creates a new query but my pivots are connected with the first one. Shortly, I dont know how to update and make some changes in my query. By the way, I want to add and delete some columns.
Can you please help?
Thank you in advance.