How Do I Add a Row to my Source Data

Hi Lucy01 - Yes, you can add a new column from your Excel spreadsheet to your Power BI report without needing to replace the entire source or rebuild everything in Power BI.

First, make sure the new column is properly added in the Excel file and saved.Go to Power BI Desktop: Open your report where the Excel file is the source.Refresh the data: In Power BI Desktop, go to the Home tab and click Refresh. This will reload the data and should recognize any new columns added to the Excel file.Ensure that your Excel file is formatted as a table if it isn’t already.Check the data model and relationships after adding the new column.

This way, you don’t need to rebuild the entire report, and the new column should be incorporated into your existing data model seamlessly.

Go to the data table and add a new row at the bottom of the table (or wherever necessary).If your Excel data is in a table format, simply go to the last row and start typing the new data. Excel will automatically add the row to the table.

In Power BI Desktop, go to the Home tab and click Refresh. This will reload your data and should pick up the new row you added in Excel.

Hope this helps.