Create From Scratch
Last updated
Last updated
This section explains the steps to create a table from scratch.
Select the option as shown below and then click Continue.
The 'Create Table' pop-window opens where you can specify the required details.
Table Name: Enter a name for your table.
Column Details: Start creating your table by adding the column name, primary key, and other relevant details like length, precision, etc. wherever applicable.
Add Column: Click on '+ Add Column' at the top of the 'Column Details' table to add a new field/column.
Advanced Properties: Check this option to add advanced properties to the column such as Display Name, Thousands Separator, Prefix and Suffix.
Click the bin icon as shown below if you want to delete that column.
You can click on Preview if you wish to view the SQL query generated which will be used to create a new table in the chosen destination.
Click Apply after entering all the column details.
You can now download a pre-configured Power BI report (.pbix file) with a live connection to the table.
If you already have an existing database, you can directly connect to it and start working on it. This is explained in the next section.
Select Connection: Choose from the list of admin or user connections, or . The supported database connections are mentioned .
If you do not want to choose any of the existing connections and would like to add a new connection, click on Add Connection. To learn more on adding a connection, refer to .
After creating a table, you can proceed to the next step: , to configure them, and then you can start working on your data.