Forum Discussion
PBI Report/Power APP cannot add or update data
Hi Anonymous when creating the Power App you must make sure that the table has got a Primary Key in order to insert data.
If you can check?GilbertQ Yes, after adding the Primary Key to the table, Insert/Edit works perfecly 💃. I followed your youtube - create the PowerApp first and then add it to my report. This went so much smoother than my earlier tests to Make new app in the report and i was getting different kinds of errors. Thank you so much for helping 😊.
GilbertQ I have a chance to check with the DBA this morning. I was not a member of the db_datawriter role (i am dataowner). DBA added me to db_datawriter to the DW DB. For a quick test, I used the 'Start from data > SQL Server ' wizard in Power App and source data from the DW DB (made the SQL connection earlier). Screen shows data from the table. I should be able to see the '+' in the top right of Power App screen if I have 'Add/Update' permission to the table. But I could only see data in VIEW mode.
Not sure what else i can check! Any suggestion please?
Hi Anonymous when creating the Power App you must make sure that the table has got a Primary Key in order to insert data.
If you can check?
GilbertQ Yes, after adding the Primary Key to the table, Insert/Edit works perfecly 💃. I followed your youtube - create the PowerApp first and then add it to my report. This went so much smoother than my earlier tests to Make new app in the report and i was getting different kinds of errors. Thank you so much for helping 😊.
Hi Anonymous
That is awesome thanks for letting us know