Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PBI Report/Power APP cannot add or update data

Please, need some help! I am trying to create a PBI report using PBI Desktop (Jan 2021 version), publish the report to PBI Service, open to edit the report in PBI Service and then embed Power APP to ...
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    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?

  • Anonymous's avatar
    Anonymous
    5 years ago

    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 ğŸ˜Š.

lbendlin's avatar
lbendlin
Super User
5 years ago

"PBI report using PBI Desktop (Jan 2021 version)" - Did you mean Power BI Desktop for Report Server?  There is no Jan 2021 version for Power BI Desktop.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    lbendlin  Yes, I am using the client Power BI Desktop (Version: 2.88.1382.0 64-bit (January, 2021) for Report Server and I published my report to our Power BI Service.  In PBI Service, I embedded Power App to try to update/add data to a table in Azure SQL DB.

    • lbendlin's avatar
      lbendlin
      Super User
      5 years ago

      Can't do that. The clients are different for a reason.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        lbendlin  Could you advise please what do I need? I have to create a Power BI report and embed Power APP to test write back. Thx