cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
uksrik Frequent Visitor
Frequent 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
karaoan
Advisor

Re: Do we have the write-back feature in Power BI by using the SQL statements like insert, update et

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

v-huizhn-msft Super Contributor
Super Contributor

Re: Do we have the write-back feature in Power BI by using the SQL statements like insert, update et

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

psolli
Advisor

Re: Do we have the write-back feature in Power BI by using the SQL statements like insert, update et

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