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 😊.
Hi Anonymous
You should be able to follow the details in the link below from the Power Apps team on how to enable write back to the data.
Creating Updateable Power BI Reports with PowerApps by Ike Ellis | Microsoft Power Apps
There also is my Youtube video showing how to achieve this: Power BI Writeback with Power Apps by Gilbert Quevauvilliers - YouTube
GilbertQ Thank you so much for the links. I will go over the steps (the Azure environment is setup by another group in the organization) hopefully i have enough pemissions. Will send an update on how it goes 🙂
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?