Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
uksrik
Regular Visitor

Do we have the write-back feature in Power BI by using the SQL statements like insert, update etc?

I have a requirement in my current reporting environment where we can allow the users to insert, update and delete the records from a particular table using the writeback feature. Can we implement the similar feature directly or by some customization in Power BI?

3 REPLIES 3
psolli
Advocate II
Advocate II

Hi,
 
Writeback to Tabluar with both Import mode and Direct query is fully support with Visual Planning from Power ON. Thers is a great video here to get you started. http://poweronbi.com/powerbi-visual-planning/
 
You can also load data from Power BI to SQL with their solutions: http://poweronbi.com/2017/06/power-update-from-power-bi-desktop-to-sql-server
 
Power ON also has a Table Editor that lets you edit SQL Tables in Power BI Service directly. http://poweronbi.com/visual-table-editor/
 
Contact info is feedback@poweronbi.com
 
Visual Planner turns Power BI into a fully fledged Goal Seek and Planning, Budgeting and Forecasting solution.
 
Note: We support Notes at tuple level in the models as well.
 
Per Solli

v-huizhn-msft
Employee
Employee

Hi @uksrik,

Then writeback feaure is unsupported in Power BI, please review this feature request below and vote it.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12903954-support-for-ssas-writeba...

Best Regards,
Angelia

karaoan
Kudo Commander
Kudo Commander

Hi @uksrik My company (www.managility.co) specialises in writeback and planning around Power BI: please have a look at: www.acterys.com 

 

It would be great to have a quick chat about your specific requirements.

 

Martin

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.