Forum Discussion

llawn001's avatar
llawn001
New Member
7 years ago
Solved

Altering Source Data in Power BI

Hi Community,

 

I am currently working on a PowerBI dashboard to present during weekly status meetings to provide 3D data to help drill down on outstanding tasks. I am struggling with figuring out how to alter my underlying source data in PowerBI itself. I would like to be able to alter individual cells within my source spreadsheets attached to my dashboard.

 

This would allow me to take input from my audience in a live fashion without having to jump between excel and PowerBI. I know that there are currently features which allow users to enter data as a new table and also find/replace data in spreadsheets attached. But I can't seem to figure out exactly how to get the individual cells to update within the BI shell itself.

 

Could anyone please let me know if this sounds like something that is possible? Or is it a feature BI is currently lacking? 

 

Thank you for the help!

 

Luke Lawn

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    llawn001 sounds like your question is more around writing data back to the source , in this case it is excel. PowerBI doesn't have that functionality but you can embed PowerApp in PowerBI which is for data entry and allows to write data back to the source. Hope it answered your question.

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    llawn001 sounds like your question is more around writing data back to the source , in this case it is excel. PowerBI doesn't have that functionality but you can embed PowerApp in PowerBI which is for data entry and allows to write data back to the source. Hope it answered your question.

    • llawn001's avatar
      llawn001
      New Member
      7 years ago

      Hi Parry,

       

      Thanks for the quick response - do you have any literature on how I could embedd PowerApp into BI desktop? I think that sounds like a possible solution to the question I posed and would like to see if I can make it work.

       

       

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        llawn001 there are lot of posts/blog on it, here is link to one. although you need to develop a powerappl (whcih is super easy) and that will get you started.