Skip to main content

Power BI

New

SQL Write Back

Vote (7) Share
Peter Howe's profile image

Peter Howe on 14 Oct 2022 10:37:51

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

Comments (1)
Peter Howe's profile image Profile Picture

Romain Pham on 05 Sep 2024 16:36:46

RE: SQL Write Back

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-overviewhttps://learn.microsoft.com/en-us/training/modules/get-started-business-performance-planning-finance/introduction