Good day beautiful people,
I'm currently working on a project where I need to enable users to add comments to tables in Power BI, and I'd like to know your opinion regarding my plan how to do it.
Here's the plan:
Objective:
I want to create a Power App that allows users to add comments to tables in Power BI.Data Source:
The source for these comments is a file(s) stored in a Data Lake within data mesh containers.Proposed Solution:
My idea is to use Power App and Power Automate to handle the comment addition process. Every time a user adds a comment, I plan to create another file in the Data Lake. Due to the limitation of not being able to directly edit files in Data Lake, I will then merge this new file with the existing data stored there or I will download both files (data source) in Power BI and then merge it there (Power Query).Questions:
- Is this approach viable, or is there a better way to achieve my goal? I believe that Power App / Automate should do the trick and it seems the easiest way to do it?
- Are there any potential challenges or problems I should be aware of with this approach?
Solution:
I believe I only need a Azure Data Lake connector to read and write the file I will generate but what about refresh process? Is it good practice to "force" refresh through Power Automate / Logic Apps or handle it differently? What else would I need to be able to save a file there?
Thank you in advance for your time!

Report
All responses (
Answers (