Updating dataset to database
I have a lot of measures fields on Power BI for calculations.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.When you cache updates, you application retrieves data from the database, caches and edits it locally, and then applies the cached updates to the database in a single transaction.
If your dataset uses a remote database server, this approach can degrade performance due to network traffic between your application and the server every time you move to a new record after editing the current record.
To minimize the network traffic, you may want to cache updates locally.
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.
When changes are complete, your application calls a method that writes the cached changes to the database and clears the cache.
Caching updates can minimize transaction times and reduce network traffic.
In turn, those design principles affect how you enter data.
Remember these facts about database objects and design as you proceed.
Go Up to Using Client Datasets Index By default, when you edit data in most datasets, every time you delete or post a record, the dataset generates a transaction, deletes or writes that record to the database server, and commits the transaction.
If there is a problem writing changes to the database, your application is notified immediately: the dataset raises an exception when you post the record.
Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.