However, cached data is local to your application and is not under transaction control.
This means that while you are working on your local, in-memory, copy of the data, other applications can be changing the data in the underlying database table.
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.
Remember these facts about database objects and design as you proceed.Hi, I have created some report on Power BI Desktop.My data sources are some excel and csv fiels on Share Point and conencted through Web URL as becasue I cannot access Share Point folder, I get "Access to the data source is forbidden" error. My data sources will be updated in every week and month.The following table lists the data types that Office Access 2007 provides and describes how they affect data entry.Text fields accept either text or numeric characters, including delimited lists of items.You can use the commands on the Datasheet tab, or you can open the table in Design view.