Forum Discussion
Advocate IICan 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.
Community ChampionIf 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.
Advocate IIOh my gosh that worked! Just had to delete the custom columns first, if any exist. I didn't really think I had any because I was thinking in terms of calculated columns, but it had added columns in for the relationships.
Other people have told me the same thing about adding a new table and deleting the old one and renaming- that it didn't work for them. But it's not really a better method, still have to add any custom columns in.