Forum Discussion
Adding Data To a Table via a Form - Possible?
Anonymous it is a great question and here is something will help.
You can create data entry app usign powerapps (which is easy) then embed that in your PowerBI.
Anonymous It depends on your requirements. If it's just the collection of a few numbers then the PowerApp integration might help you. If you are looking for serious planning functionality, you might want to have a look at: www.acterys.com This solution offers sophisticated write back and planning for Power BI and Excel. In addition to writing to a relational table the solution offers a powerful OLAP in-memory engine on top of SQL Server that caters for large scale multi user write back requirements that typically don't work with sufficient performance if you just write to a relational table.
Martin
Hi Martin - thanks for the reply. I ended up building a form in PowerApps which seems to do the trick. There are are a few limitations to it (i.e. anyone who wants to use it needs an organisation login) but for the most part it's worked out well.
Sam
Anonymous - I am trying to build a form on Power BI, that will perform a write-back operation to my database. I know this can be accomplished using Power BI, but I have an issue when I try adding a new form - I'm not able to see a datasource linked to the form object. All I see is a gallery which is linked to the Power BI data source. Can you please help me understand how you built the form? Your help is much appreciated!