How To Add Data In Power Bi Table

How to Add Data in Power BI Table

To add data in Power BI Table, follow the steps below:

1. Open Power BI Desktop.
2. Click on the “Home” tab in the top menu.
3. Click on the “Get Data” button.
4. Select the source from which you want to add data. Power BI supports various data sources such as Excel, SQL Server, CSV files, etc. Choose the appropriate source and click on it.
5. Provide the necessary credentials and access information to connect to the data source.
6. Select the specific table or tables you want to add data from, and click on “Load” or “Transform Data” depending on your requirement.
7. If required, you can perform data transformations, cleaning, and shaping on the data using the Power Query Editor.
8. Once you are satisfied with the data, click on “Close & Apply”.
9. The selected data will now be added to the Power BI Table.

Here’s an example:

Let’s say you have an Excel file named “SalesData.xlsx” with a table named “Sales”. To add this data to Power BI:

1. Open Power BI Desktop.
2. Click on the “Home” tab in the top menu.
3. Click on the “Get Data” button.
4. Select “Excel” as the data source.
5. Browse and select the “SalesData.xlsx” file.
6. Click on the “Sales” table in the Navigator window.
7. Click on “Load” to directly load the data, or “Transform Data” to perform additional data transformations.
8. Perform any required data transformations using the Power Query Editor.
9. Click on “Close & Apply”.

The “Sales” data from the Excel file will now be added to the Power BI Table.