Forum Discussion
Power BI report for Sales KPI by multiple user input
Hi All,
I am planning to create a PowerBi report where i can ask multiple persons to input their respective data and then this report should be published to stakeholders.
Basically i want to add daily sales data from each showroom and showroom person will add his daily sales data and consolidated report should be sent automatically to stakeholders daily.
Currently we are manually collecting the report from each showroom, then adding it to excel and publishing a daily report. I want to automate this process.
Kindly assist in achieving the same. Thanks in Advance.
2 Replies
CoreyPSolution Sage
What's the systems architecture like? Do the showrooms all manage their own sales data independently? Or is there a financial system your company uses?
miTutorialsSuper User
You can create a form in Power Apps and integrate within Power BI which will write back to Database. If you use Direct query your stake holders will have live access to the report.
Check out the below tutorial.
Best regards,
Ismail | MiTutorials
🎥 MiTutorials on YouTube Explore over 200+ Power BI tutorials and enhance your skills!