Forum Discussion

Kobe100's avatar
Kobe100
Frequent Visitor
2 years ago

Write back Powerapps and Power BI

Dear All, hope you are doing well.

 

I have developed the following report and app with the right back to the data source  which is excel (saved in one drive). The issue I am getting is that sometimes the lines item gets updated but other case it does not. See below:

 

When I select a line form the table the apps need to retrieve the data from data specific row. The fields that need to be updated are Decrement, Adjusment and Comments. But when I click submit sometimes the data is transmitted to the source file but not all the time.

 

Appreciate any support on the topic.

 

Thanks,

4 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion

    Hi Kobe100 

    Once data are not showing in Power BI after updating, could you please check the OneDrive excel file that data are update in data source or not

    • Kobe100's avatar
      Kobe100
      Frequent Visitor

      Hi PijushRoy 

       

      Reviewing the data source now I see my inputs ( seems to be it take a long time to update the excel) and now they are reflected in Power BI. 

       

      Now the question is how can I improve the update process when I submit the form to the excel file?

       

      Thank you in advance

      PREVIEW
       
       
       
      • PijushRoy's avatar
        PijushRoy
        Community Champion

        Hi Kobe100 

        What is your data volume?
        Please add a unique field in your file like Index
        Please use Database or Dataverse for the best performance

  • Kobe100's avatar
    Kobe100
    Frequent Visitor

    Hi @PijushRoy,

     

    Reviewing the data source now I see my inputs ( seems to be it take a long time to update the excel) and now they are reflected in Power BI. 

     

    Now the question is how can I improve the update process when I submit the form to the excel file?

     

    Thank you in advance

    PREVIEW