Planning in PBI - Insert values(rows) in existing table(from MS SQL)

[Anonymous]

Hello guys,

First: I'm using Microsoft Power BI Desktop (Optimized for Power BI Report Server - January 2020) and Microsoft Power BI Report Server - January 2020

I'm trying to the following thing - I have a table from MS SQL DB. I want from PowerBI Report view to be able to anter variables wich will affect the result in the matrix table (users to be able to enter this variables).

The idea is to make some kind of Plan Cash Flow, but i would like to be able to put variables (Column Amount) for specific date (Column Date).

I'm not sure that i can explain you correctly, that's why i made ax Excel table for the example:

Sheet Table - this represents the SQL table i have imported in Power BI. The yellow rows are the desired values entered somehow manually in PowerBI:

Pivot Table - this represents the Matrix table in PowerBI, in yellow again are the desired values entered manually. You can see that they affect the totals and the grand totals of the table:

Excel file is in the link below. Thanks a lot!

https://drive.google.com/file/d/1o5nNk1IVbIqPOzXsBneEGU5O8fjShxPJ/view?usp=sharing

[Icey]

Hi @Anonymous ,

How about using Power Apps to write back the records you entered to data source (MS SQL)?

Reference: 

Using Power Apps in Power BI reports: Enabling writeback;

Writeback to database using Power app with Power BI interactive;

Write Back into Azure SQL Database using Power BI in Power Apps.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.