Hello everyone,
Problem statement: We want to remove data from excel workbook and save customized workbook to Dataverse table.
Scenario: We are storing excel workbook in Dataverse table in body binary field. User can visit our app, download the excel workbook in local disk. This excel has a connection with PowerBI dataset.
When user open the excel, data got populated using the connection. User can do customization and save them.
Requirement: Our requirement is to save the customized workbook back to Dataverse table but without the data.
Can anyone please suggest how can we remove data from excel workbook?
