Solved: Can we update the dataset without deleting and add... - Page 2

kpatterson2 · ‎08-13-2015

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 i really have to do to see the changes? I would think every user would think this is a major problem.

Greg_Deckler · ‎08-13-2015

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.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Can we update the dataset without deleting and adding again?

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024