Forum Discussion
Adding columns to my report
I created a report and dashboard in Power BI Desktop using data from an Excel file. Since then, I’ve added two new columns to the Excel source and would like to include them in my existing report.
Is there a way to import these new columns into Power BI without having to recreate my report and dashboard from scratch?
All you should need to do is add the new columns in your source and then hit refresh in the Power BI desktop file. Then click publish and upload it to the correct workspace.
2 Replies
All you should need to do is add the new columns in your source and then hit refresh in the Power BI desktop file. Then click publish and upload it to the correct workspace.
You don't need to recreate anything. In Power BI Desktop, go to Home → Transform Data to open Power Query. Your Excel connection is already there — just close and apply, or if the columns aren't showing, right-click the query and hit Refresh Preview. The new columns will appear in your field list and you can add them to visuals from there.
If the columns still don't show, check that they're in the same sheet/table range your query is pointed at. If your Excel source uses a named table, new columns inside that table are picked up automatically. If it's a range, you may need to adjust the range to include the new columns.
