Forum Discussion
Can we insert Or Update records in SQL Server table using Power BI report
Hi All, I hvae table in Sql Server like Employee with EmployeeName and Officecodes attributes. I hvae to insert the values into a table using POWER BI report is it possible? Base table like ...
Technically, you could abuse the Sql.Database() function in M in some way to run arbitrary SQL against a database. However, this is a bad idea, and you probably shouldn't do this. Giving a BI tool write access to a database is just asking for horrible things to happen to both your data, as well as your employment status at your company.
At the Insights Summit, they announced an incoming integration with PowerApps and Power BI. If I were you, I'd wait until this feature is released and fleshed out if you really want both read and write capability out of your Power BI dashboards.
Hello Sonny,
Thank for your replay.
This is my requirements to give the ui based report to user , then user wants to insert records into the existing table.
I did in .net but client want s to do the UI in power bi only. Already I informed to him only we can visualize the data through power bi but not using as UI.
Thank for your replay.
This is my requirements to give the ui based report to user , then user wants to insert records into the existing table.
I did in .net but client want s to do the UI in power bi only. Already I informed to him only we can visualize the data through power bi but not using as UI.