Creating a comments table against individual transactions on a listing

[PYarwood98]

I am downloading a listing of transactions from a database via a custom connector, and I need to find a way to populate a comments field next to each transaction, so that users of the report can add comments against individual lines.

I intend to create a SQL table which can hold the comments, stored against the unique transaction reference code so that they are displayed for reporting each time the visual is opened.

Any suggestions as to the best method for doing this please? I have seen a couple of tutorials that suggest creating a PowerApp visual for this, but not sure if this would be the best option.

[Anonymous]

Hi @PYarwood98 ,

Please check the following methods, hope they can help you:

1. User PowerApps Visual

Adding Comments & Sending Emails in Power BI using PowerApps

2. Create a separated comment table just as you referred and load it in Power BI

3. Use built-in comments feature

Power BI data write-back with Power Apps and Power Automate - Azure Architecture Center | Microsoft ...

Add comments to dashboards and reports - Power BI | Microsoft Learn

Best Regards