Forum Discussion

kpatterson2's avatar
kpatterson2
Advocate II
11 years ago
Solved

Can we update the dataset without deleting and adding again?

The only way I know how to update my dataset in Power BI is to delete it and add it again, which deletes associated reports and dashboards. If I simply add a new column to my data model, is that what...
  • Greg_Deckler's avatar
    Greg_Deckler
    11 years ago

    Typically, I work with Excel or Power BI Desktop programs and build my data model there. You can, under specific circumstances, add a column for instance and the next time you refresh, it will be added to your data model. This does not tend to work if you create calculated columns. You have to remove the calculated columns and then refresh and then add the columns back.

     

    If you do it this way, update the data model and then load the PBIX or Excel file and overwrite the old data set, you will not break all of your reports, dashboards, etc.

car16's avatar
car16
New Member
7 years ago

Does anyone know if it's possible to delete columns from your existing excel source data that you are then using in Power BI?  I have imported an excel file with several columns of information that I do not need in Power BI.  The employee who owns the excel file wants to delete several columns.  When I delete the columns from excel and then refresh in Power BI, I receive an error saying I can't refresh because "the column can't be found".  If I delete it out of Power BI as well, I receive the same error.

 

Any thoughts on this?