Forum Discussion

kpatterson2's avatar
kpatterson2
Icon for Advocate II rankAdvocate 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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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.

Deborah1982's avatar
Deborah1982
New Member
9 years ago

Hi,

Are you saying that if I have a calculated field, there is no way I can update them with new data?

For example:

I have an excel with 4 tabs: 2013 - 2014 - 2015 - 2016

I have uploaded those 4 tabs in BI.  I have append all tables into 1 big table.  So I have all data from year 2013-2016.

I have added some columns with calculations.  For example to calculate total profit, total proc price, etc......

This is working perfectly.

 

I have now next tab in xls: 2017

I have uploaded this in BI, and append in the big table.  This was all working BUT the extra fields I had created does not contain any data for 2017 (total sales, total profit, etc....). 

How can I change this without deleting the whole column and create this again?

There are a lot of charts and tables created with special filters, if I have to create the columns all over again, each time I have new data, it will consume a lot of time, if I take the wrong title, all my charts/tables will be corrupted.

Do you have a  solutions for me?

 

Kind regards

Deborah