I know write back to SQL can be achieved using partner visuals or power apps, but it seems to be a fairly simple problem that could be resolved by imbedding a write enabled table visual. Why? ...
Hi Peter,
We heard your feedback and have release this feature as part of our Dynamics 365 Finance Premium Offering, to help all FP&A Professional to plan and prepare their Budget/Forecast/Plan directly from your favorite reporting tools. You can now write back in Dataverse directly from Power BI through specific visual and Excel Pivot Table.
Find all about it here:
https://learn.microsoft.com/en-us/dynamics365/finance/business-performance-planning/business-performance-planning-overview
https://learn.microsoft.com/en-us/training/modules/get-started-business-performance-planning-finance/introduction
