Adding new data to existing data

[EvansB2]

Hi there,

I am relatively new to Power BI and am finding my way round the fundementals.

I have imported my data directly from excel and set-up some visuals and all working fine. I have realised that I need to add a column of data from the same original source but I didn't think i need it so I didn't import it.

How do you udate the existing data, i.e. add the ne column of data, without having to start a new document?

Any help would be apprecated

Regards

Ben

 

[macfuller]

Welcome to the PowerX world. It can be a tough learning curve but stick with it, you won't regret it.

If you imported the data model from the excel worksheet then you'll probably need to update the data model in the source and refresh the data in your PowerBI file. If the Excel data was just from a worksheet then you can edit the PowerBI query to not exclude (a subtle difference from include) the "new" column. It depends how you created the original query - if one of your steps was to Delete Other Columns then the query will show a list of the deleted columns like {"Column 1", "Column 2", ...}. You can remove the column you want to keep from this list, re-run the query, and format the column if needed. On the other hand if your query was set to Include only certain columns, then you can add the column you want to the list in a similar format and re-run.

 

[EvansB2]

Thanks for the information, much appreciated. I will have a play and see which works best for me.

Regards
Ben