Forum Discussion
Can we update the dataset without deleting and adding again?
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.
If you have custom columns, it will never update the schema, you have to get rid of those first. Get rid of your custom columns first, then just refresh, don't create a new query, should plop your new columns in, add calc columns back.
I've never really had success doing what you are doing, something about the rename process just doesn't really work well in my experience.
So while that sort of solved one problem for me, were you saying earlier that you can overwrite the data set in powerbi.com without deleting any reports or dashboards?
I update my Excel and PBIX data sets and my dashboard stays how it is other than the data being updated. I can't say that I've specifically tested reports, I'll have to test some of that. When you upload the file, it should prompt you if you want to overwrite the data set.
Ok, I see how you get the message about replacing the file- it appears if you click "Get Data" in the bottom left as opposed to clicking the + sign next to Datasets. However, it did not ask me that question if I picked a file from One Drive, which is where my Excel file is. When I picked "local file" option, it did ask me that question and I've been getting an error though after clicking to replace the file. I tried replacing a different dataset and it worked without an error but not really- I didn't see my new columns. So still a little puzzled
I closed my browser tab and opened a new session and now I see my new columns! :)