Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create a sign off feature for end-users.

Hello,

I have created reports on PowerBI which will be deployed to various users with RLS built in to limit access to the cost centers/departments that they can view. Report has 7 pages. I want to build a feature on the report that will enable the cost center owners to sign off on the report and that should trigger to write information on a file saved on Teams/SharePoint Site.

Here are few information I need:

  • User Name
  • Date/Time Stamp on when they signed off on the report
  • Certain filters that were applied on their report when they signed off (This is to make sure they are signing off the correct period).

 

I am not sure if its better to use Power Automate, Power Apps or if there is another way to integrate a feature like this on PowerBI. Any ideas are welcomed.

6 Replies

  • Hi Anonymous !

    You can use Power Apps to get around this feature. You can integrate Power Apps visual in your Power BI report.

    Using Power Apps you can read / write information from Share Point List or Share Point site providing you ability to write objects in Share Point folder.

     

    Regards,

    Hasham

    • Anonymous's avatar
      Anonymous
      Not applicable

      My only concern is if the RLS in PowerBI will still work in PowerApp. For example, would user only see the departments that they have access to in the PowerApp visual or will they see all cost centers?

      • HashamNiaz's avatar
        HashamNiaz
        Solution Sage

        You need to ensure this through Data Model, so only associated cost center will bee shown. Also you can implement security in Share Point site.

         

        Regards,

        Hasham

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support

    Hi Anonymous ,

    Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.
     
    Best Regards
    Lucien
  • Hi zzakir, wondering if you were able to accomplish the sign off with the time stamp and if so, can you please share your steps?