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 below

EmployeeName  OfficeCode

   ABC                    NSA

 If i want to add any reocrd int the existing table I dont want to use any sql / .Net application.

I want to insert the values through my Power Bi report.

 

Regards,

Anil

Need Help

7 Replies

  • psolli's avatar
    psolli
    Advocate II
    9 years ago

    Hi All,

     

    Development in Power BI is going so fast it is hard to keep up. Power BI is a FANTASTIC system for entering records, updating numbers, and goal seeking DAX formulas. You can your Visual Planning from Power ON.

     

    Here is a great link to get started: http://poweronbi.com/powerbi-visual-planning

    There is a great video to get started. The cool thing is that it works from Excel to Power BI as well.

     

    Additionally you can use Power Update to Load all Data from a Power BI data model to SQL for easy ELT (Extract Load Transform) modification of data. https://twitter.com/PowerONbi/status/887673890167803904

     

    http://poweronbi.com/2017/06/power-update-from-power-bi-desktop-to-sql-server/

     

    Please help spread the word about using Power BI for Corporate Performance instead of Anaplan, IBM Cognos TM1, SAP BPC, Hyperion Planning and other pricey tools.

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    Hi AS_1521,

     

    PBI is a business analytics tools as such it does not allow you to add values to your database, you can only extract and analyze your information in different ways, it's a Business Inteligence progam as such not for inputs but for data analytics.

     

    Regard,

    MFelix

  • 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.
    • AS_1521's avatar
      AS_1521
      Regular Visitor
      9 years ago
      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.