# Use Existing Table

This section explains the steps to connect to an existing database from the console.

1. From the console, you can connect to the database by clicking on the **Use Existing Data** option as shown below:

<figure><img src="/files/Tg5rciPb6gbbPCrFpUxm" alt=""><figcaption><p>Use Existing Data</p></figcaption></figure>

2. The 'Create Table' pop-window opens where you can specify the required details.

<figure><img src="/files/P0VMyyFAXFptONWd99ap" alt=""><figcaption><p>Create table pop-up</p></figcaption></figure>

3. **Select Connection:** Select the database connection that contains the data.

<figure><img src="/files/DcRIAhrvDedF5To3BFip" alt=""><figcaption><p>Select connection</p></figcaption></figure>

4. **Select Table:** Select the required table from the dropdown list.

<figure><img src="/files/LRhswnwJoZAA2uD6oPi1" alt=""><figcaption><p>Select table</p></figcaption></figure>

5. **Column Details:** Verify the column details and edit them wherever required.

<figure><img src="/files/oIZiLMQ0sDHg6PWsCBhi" alt=""><figcaption><p>Edit column details</p></figcaption></figure>

6. Check the **Advanced Properties** option to view the advanced properties such as Display Name, Thousands Separator, Prefix, and Suffix.

<figure><img src="/files/HTgJY2hkeDtTz4gQtYjV" alt=""><figcaption><p>Advanced Properties</p></figcaption></figure>

7. Click **Apply** and then click on **Download Report** to download a pre-configured Power BI report (.pbix file) with a live connection to the table.

<figure><img src="/files/Nd6gt0wJyLbRIN5NYY7p" alt=""><figcaption><p>Download Report</p></figcaption></figure>

8. Click to open it. You can notice the pre-populated visual along with the assigned fields in the Visualizations pane. The system will prompt you to sign in. Click on **Sign in with Office 365** to sign in to the workspace.

<figure><img src="/files/vag8vAtQFBNQBAcPyixD" alt=""><figcaption><p>PBIX file with a live connection to the database</p></figcaption></figure>

{% hint style="info" %}
Close the 'Pause visuals' suggestion tip. **Do not pause the visuals** so the live changes get synced to the database.
{% endhint %}

You can now start managing your data from Power BI. Any changes made to the table in EDITable, after saving (or after approval, if enabled), get applied to the database it is connected to.

The next step is to [manage columns](/working-with-editable/manage-columns.md) to configure them, and then you can start working on your data.

The next section covers how to import your data from spreadsheet files into a database.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.editable.io/getting-data-into-editable/create-a-table/use-existing-table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.