Unable to add new table from excel

[Sanjayroutela]

Hi,

I successfully created 7 power bi reports by connecting it to an excel sheet and now if i am making any changes in excel, they are successfully updating in all the reports.

But later on, i added one more table in my excel file(due to some business requirement) and now i want to load the data of same in my PowerBI report but simply clicking on Refresh data is not helping.

Is there any way through which i can start importing the values of that new table(added in excel) into PowerBI as well?

[Sanjayroutela]

Great, thank you for the detailed steps.

[foodd · Accepted solution]

If you have added a new table in your Excel file, and it is not automatically showing up in your Power BI report after clicking on "Refresh data," you may need to follow these steps to import the new table into your Power BI report:

1. Verify Excel Connection:
- Open your Power BI report and go to the "Home" tab in the Power BI Desktop.
- Click on "Transform data" to open Power Query Editor.
- In Power Query Editor, check the "Queries" pane on the left side to see if your Excel file is listed. It should have the tables you previously imported.
- If the Excel file is not listed, you may need to reconnect to the Excel file. Go to "Home" > "Get Data" > "File" > "Excel" and select your Excel file again.

2. Refresh Data in Power Query Editor:
- If your Excel file is listed in the "Queries" pane, select it, and then click on "Refresh" in the top ribbon of Power Query Editor.
- This will reload all the data from your Excel file, including the newly added table.
- You should see the new table in the Power Query Editor now.

3. Import the New Table:
- In the Power Query Editor, locate the newly added table in the "Queries" pane.
- Right-click on the table and select "Load To..." to import the new table into your Power BI report.
- Choose whether you want to load the table to a new worksheet or an existing worksheet in your report.
- Click "Load" to add the new table to your Power BI report.

4. Update Data Model Relationships (If Needed):
- If the new table has any relationships with other tables in your data model, you may need to define or adjust those relationships in the "Diagram View" of Power BI Desktop.

5. Refresh Your Report:
- After importing the new table and making any necessary data model adjustments, click on "Close & Apply" in the Power Query Editor to apply the changes to your report.
- Click on "Refresh" in the Power BI Desktop to refresh your entire report with the updated data.

By following these steps, you should be able to import the values of the new table added to your Excel file into your Power BI report and see the data in your visuals.