Altering Source Data in Power BI

[llawn001]

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

[parry2k · Accepted solution]

@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]

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]

@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.

[llawn001]

This looks to be exactly what I need, however I don't see any for data entry unfortunately. Is there a way that I can develop my own? I don't know that I would be able to tackle the development myself but I'd like to at least give it a shot.

[parry2k]

@llawn001 yes you can develop your own. https://powerapps.microsoft.com/en-us/

There are lot of videos, just sharing home page link, also you can search for powerapp to learn