Is it possible to create a report that builds a purchase order

[RossS]

I have a report that is a table visual which contains what products our suppliers are offering. Each line is a different product with the cost, supplier name, how much we've last paid for it, etc. Our purchasing team will be using this report to look for good offers from suppliers and then to build a purchase order.

Is it possible for a user, in Power BI Service, to select a product in the table which would autoamtically be added to a new table? They would need to be able to adjust the price and quantity of each product which would automatically adjust the total cost for the item and purchase order. Some of the information from the original table would need to be excluded from the new table.

Supplier Name	Product Description	Cost	Last Cost	Price + shipping	Qty in Stock	Qty Reserved
Microsoft	PC	£75	£85	£77	120	£100
Microsoft	Keyboard	£10	£8	£12	0	0
	Purchase Order
Product Description	Cost	Qty	Total Cost
PC	£75	100	£7,500
Subtotal			£7,500

[danextian]

Hi @RossS 

What you're trying to do requires a writeback which Power BI doesn't natively support. While you can use PowerApps and Translytical Taskflow (in Fabric), it won't be as simple as editing a cell in your invoice table. There are custom visuals that support writeback but they do come with a hefty price tag possibly because of the architecture involved.

https://marketplace.microsoft.com/en-us/marketplace/consulting-services/pomerolpartnersltd.peraison_...

[johnbasha33 · Accepted solution]

Hi @RossS 

The best solution: embed a Power Apps visual inside your report

This is actually a pretty well-known pattern for exactly this kind of scenario. Here's how it works:

1. Add a Power Apps visual to your existing Power BI report. This is a built-in visual you can get from the visual gallery.
2. Power Apps receives the selected row(s) from your product table as context — so when a user clicks on a product, that data is passed straight into the app.
3. Inside the Power App, you build the Purchase Order interface — users can adjust quantity and price, and the app calculates the totals dynamically.
4. When they're happy with the PO, you add a Submit button that writes the data to a backend — SharePoint, Dataverse, or an Excel file are the most common choices.

This gives you exactly what you're describing: a seamless experience inside the Power BI report where the purchasing team can click a product, build their PO, tweak quantities/prices, and submit it — all without leaving the report.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[RossS]

I have inserted a Power Apps visual into my report and then added some columns. When I open Power Apps from the visual, there is no data connected. I suspect it is because I don't have a data gateway setup and the source of my data is on premises. Is this likely or should it be possible to connect to the data as it is coming from Power BI service which is therefore in the cloud?