Efficient Manual Data Input for LARGE numeric ranges?

I'm working on a Power BI report that includes inventory tracking with a barcode scanner. Here's what I need help with:

1. Context: After scanning a product's barcode, the report filters to show that product's data, including a field called Inventory, which represents the current stock level.

2. Objective: I want to create a workflow where end users manually input the physical inventory count (i.e., a "Physical Inventory" value) into the report after physically checking the stock. This input should then be stored in an Excel table, including:

   • The product code,
   • The physical inventory entered by the user,
   • A calculated difference between Inventory (Power BI’s stock level) and the Physical Inventory input.

3. Current Approach and Challenge: I tried using a Power BI parameter with a numeric interval, but because stock values can range into the millions, it drastically impacts performance.

4. Preferred Solution: I’m exploring embedding Power Apps within Power BI for this input field, linked to Power Automate for automated storage in Excel. However, I’m unsure if this will integrate as smoothly as needed.

Question: Is embedding Power Apps the best approach here, or is there a simpler way to handle this large-range numeric input directly within Power BI? If Power Apps is the best method, any tips on efficient setup and avoiding performance lag would be greatly appreciated.

Thank you in advance for your insights!