Forum Discussion

AS_1521's avatar
AS_1521
Regular Visitor
9 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.

  • AS_1521's avatar
    AS_1521
    Regular Visitor
    9 years ago
    Thank you Vanessa for your reply.
    Yes previously I was posted related to publish on web rls report. It's not possible. With out rls we can published on the web.
    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      9 years ago

      Hi AS_1521,

       

      As disscused above, Power BI is a Business Inteligence tool for users to fetch and analyze underlying data. Currently, it is not possible to consider a Power BI report as UI to edit or insert data records in database.

       

      Regards,
      Yuliana Gu