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
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.