Use Existing Table
Last updated
Last updated
If you have data in any of the databases, you can connect to it in two ways:
-> Using the Get Data option in Power BI and then connecting to data through Direct Query mode
To connect from a Power BI report using Direct Query mode, you can refer to this section: Connect to existing database
-> Using the option, Create Table -> Use Existing Data in the console
This section explains the steps to connect to an existing database from the console.
From the console, you can connect to the database by clicking on the Use Existing Data option as shown below:
The 'Create Table' pop-window opens where you can specify the required details.
Select Connection: Select the database connection that contains the data.
Select Table: Select the required table from the dropdown list.
Column Details: Verify the column details and edit them wherever required.
Check the Advanced Properties option to view the advanced properties such as Display Name, Thousands Separator, Prefix, and Suffix.
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.
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.
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.
