Solved: Using PowerBI to update tables in a sql server dat...

Seankew · ‎05-09-2017

Can PowerBI push updates to tables on a sql server database? This seems to be a feature gap with most data visualization tools. The use case for me is having a manager view their financial position in a PowerBI Dashboard, and allowing the manager to enter a forecast amount directly into the dashboard, which would update a record / field in a table stored in a database housed on one of our sql servers.

v-caliao-msft · ‎05-10-2017

@Seankew,

Power BI is a data visualization tools. Current, there is such an option to allow end users to change the data in your dashboard and then update it to your source table. In you want to update your data, you could create your own application, and then embed Power BI report to your allication.

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Charlie Liao

View solution in original post

v-caliao-msft · ‎05-10-2017

@Seankew,

Power BI is a data visualization tools. Current, there is such an option to allow end users to change the data in your dashboard and then update it to your source table. In you want to update your data, you could create your own application, and then embed Power BI report to your allication.

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Charlie Liao