Building a editable table for BI table visual

[Anonymous]

Hi all, I am looking for a way to achieve:

1.) Build a table visual(7 columns) in PowerBI - Completed

2.) Use this table visual to build a PowerApp which will be embedded in the PowerBI

3.) In the PowerApp, build a Editable grid for user to fill. (In the Editable grid, 7 non-editable columns are from PowerBI table, 1 editable column is from AzureSQL)

4.) After user fill in the editable column, the submit button will update the data in the SQL table.

I could not find any solution online for editable grid on PowerBI and able to submit to SQL

May I seek some advise or help here? Appreciated.

[lbendlin]

Read about Field Parameters.  They can be used to let users dynamically modify dimensions and measures. Check if the Field Parameter is accepted by the PowerApps visual.