Keep in mind, the Excel file approach is subject to bad performance, conflicts of updates, and the potential for the entire Excel workbook to get deleted/manipulated. This will allow it to be delegable, and give you much better access to the data. Not ideal, but a possibility for slow moving data.Īlternatively, you can (and should) move this data into CDS.
It will require, however, that changes to the data be updated manually in the app. This will allow you access the entire dataset, without delegation issues, and increase performance substantially.
If the data is slow-moving, then you can consider loading it into the app as static data. It will only retrieve X rows, as configured per your app (up to 2000). How often does this data change? As noted, this particular configuration (Excel file via (presumably) OneDrive for Business) is not delegable.
0 kommentar(er)
