I'm moving one of our reports from a byzantine mess of excel macros and ftp file management to power bi and apis, and I have it mostly sorted. One feature for this report that has been requested by my team is ability to add notes / comments.
Currently we run this report 2 times per day, and occasionally more during especially dynamic days (I could easily see 5-6 runs on such a day). If I use the power apps methodology that I've seen documented, for it to work well it appears to basically double the refreshes we would do to have the notes pop up on what people see (Run the report, talk about it, add notes, refresh to see the notes that have been added since it would pull from the sharepoint list or excel file the power app wrote to). We all have pro, but it may be possible to get premium for one or two of us.
Using the native comments may work, but I'm foggy on how it would work with exporting the data for records. I think the best solution I'm seeing so far is using the native comments, then exporting a pdf to retain a record that is searchable. But then the comments are capped at 2,000, and yesterdays notes would show when the data was refreshed for todays report which could be confusing.
Anyone have better ideas?
People other than myself present the report to the group, and it's best to not have other people go into the report and edit it, rather I just want them to run it via the service on the web. I want it to be a system that less savvy pbi people can use and not risk screwing up the report. I haven't seen a new thread about this in 4 years, so figured there may be better options now.
