Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have a situation where we have a number of new campaigns coming from different departments which we want to track in PowerBI. I'm wondering if there is a way for me to create a form that each department would fill out that would then be added to a data table that I could then use as a lookup for data being generated from other sources.
An example: Campaign XYZ is being run by Department 123. Someone in this department would go into PowerBI and fill a form with a field for campaign name and for department ID - after submission, this information would then go into a data table in the columns campaignName and departmentID. When data about campaign XYZ then starts coming through I would could then see that Department 123 set this up and attribute the data to them.
I'm not sure this is possible and am thinking that I might need to do this maybe through a webform that adds to a database which is then pulled in PowerBI. However, if I could do everything in the one place it would make life much easier!
Hope that makes sense.
Thanks,
SamB
Solved! Go to Solution.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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!
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |