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:

Use Existing Data

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

Create table pop-up

1. Select Connection: Select the database connection that contains the data.

Select connection

1. Select Table: Select the required table from the dropdown list.

Select table

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

Edit column details

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

Advanced Properties

1. 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.

Download Report

1. 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.

PBIX file with a live connection to the database

Close the 'Pause visuals' suggestion tip. Do not pause the visuals so the live changes get synced to the database.

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 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.