A power bi newbie here.
Say if I import a table A from a data source into power bi, some minor changes to the imported dataset. calculated columns, measures etc.
Now I add a new field in the table A, how do I include the new field into the data set in power bi (without re-creating a new one)?
Thanks in advance.
Solved! Go to Solution.
I had the same issue - with Excel tables I couldn't perform the steps mentioned here as they apply only to CSV files.
I found a workaround for Excel files/tables that seems to work for me, so thought I'd share it.
I found that I had to save a copy of the existing file e.g. save as Filename_1 or similar, then go data source settings, change data source and select the new file. The new columns then appear.
You could then go back and save as the original file name, and change data source back to that again to retain the existing file.
Hope that helps.
@elsalvador182 Thank you for that. I actually couldn't do exactly what you said because my csv file is updated from Sharepoint but the premise helped. When I inserted the step to import CSV, it inserted the whole document with the last column which had fallen off due to the new column being added. Then I could delete the old "import CSV step" and my steps all worked from there on to the end.
It was driving me crazy so thank you for taking the time to add your solution to help someone who needed it...ME!
I expected the functionality to work as you explained, but it doesn't for me.
I am using a local file. It is an Excel spreadsheet with a table. The table has 4 columns. If I add a fifth column with data, I would expect the field to show up in Power BI after a refresh. I click refresh for the datasource and it refreshes successfully. Then, I go to report and the new field does not show up. The only way to get the new field is to delete the old datasource and add a new one.
I have the same problem: If I add a column to my original data source in Excel and refresh in Power BI, my new column doesn't show up. Is it possible to get the new column or is the only way to start from scratch? (I'd rather not since I've build relationships to other sources, added calculated columns, etc.)
Click here to read more about the June 2022 updates!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.