Forum Discussion
Power BI Custom Visual - Web API for edit the data of excel data source
Hi Guys, I'm developing a powerbi custom visual. There I need to edit the data pieces of individual cells of the excel data source bound with the visual. I was just researching on that, and fou...
You cannot modify individual rows/columns of a semantic model. The smallest change you can make for regular semantic models is a flush and fill of a partition. For streaming datasets the smallest operation is to push a single row.
If you want to modify the content of the Excel file that is the source of your semantic model then you could use the Graph API, but that will be meaningless as that change will not be reflected back in the semantic model until after the next semantic model refresh. Excel files are not suitable for Direct Query connections, they are Import Mode only.