One way to write comments in a Power BI report using write-back functionality with Power Apps without having a Comment column in the data source is to use a separate data source to store the comments. You can create a new data source, such as a SharePoint list or Excel file, to store the comments. Then, you can create a Power App that allows users to enter comments and save them to the separate data source.
Next, you can add a button or other control to the Power BI report that triggers the Power App to open and allow users to enter comments. When a user enters a comment and saves it in the Power App, it will be saved to the separate data source.
Finally, you can add a visual in the Power BI report that displays the comments. You can use the Power BI "Web" visual to display the comments from the separate data source, or you can use Power BI's built-in "Get Data" functionality to connect to the separate data source and display the comments in a table or other visual.
Overall, this approach allows users to write comments in a Power BI report without having to add a Comment column to the data source, and it provides a centralized location to store and view the comments.
