Report Connected with Updated File

[Ujjawal]

I have uploaded an excel file to SAS Visual Analytics. Then I created a report in which i have added multiple calculated items. Later main data file got some changes and some new columns were added. I have uploaded a new excel file to SAS VA. When i connect a new data file to my report, old data connections and calculated items got removed. How can i prevent it in future reports? Or can i fix it in the current report? I heard some autoupdating functionality to fix it but dont know exactly the steps.

[ImVickie]

Hi Ujjawal,

I also faced the same problem,

What i do for this i will share with u, 

U also Try and Let me know if its working or not

1. Load the table, make the report then save it.

2. Open new report > Click On Add Data Source > Add your new Excel with changes > Give the same name > Refresh the data 

3. Close the new report > Open your Old Report > Refresh the Data.

this steps work fine for me..

Thanks

Vicky