DB Settings

User needs to align a return workbook or Database when it is moved to a different location, otherwise you may have limited access to the full features of Tabular.
There are two different processes involved, depending which needs to be aligned: a return workbook or the path to the database

Here’s how:

A. If it is a return workbook moved to a different location, opening the return will give you a warning message that you need to update the path in the main DB.
1. Sign in as administrator in the log-in area of the open return.
2. Go to System Admin in the ribbon and click DB Settings.

3. Click Update in the dialogue box.

4. A message will show to confirm that path is successfully updated.

B. When the central DB is moved to other location

1. Open the main Tabular workbook and log-in as Administrator.
2. Go to System Admin in the ribbon and click DB Settings.
3. In the dialogue box, select the path where the new central DB is located and click Update. Note that the path should be to ProgramData folder (do not add the file name as well, just the ProgramData)

4. A confirmation message will show once update is successful