SQL Write Back

[phowe]

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?

Many of our users download data to excel or PDF to highlight and annotate visuals. We want to encourage users to rely on Power BI as the single source of truth, but the lack of functionality drivers technical people to move the Power BI models to excel, which then leads to unknown and unsupported changes

[romainpham]

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