Forum Discussion
PowerBI "Audit Log"
Hello,
I have a PowerBI build based off of Excel Files.
I want to create an audit log where it will tell me who made changes to the Excel File - the user and what cell/field they changed.
Is this possible?
Could anyone help with links or ideas?
TYIA
It's been a while since I've used PowerAutomate but if the Excel files are stored on SharePoint 365/Teams, with a bit of work it may be possible to set something up with PowerAutomate to make a record of who changed what.
I think their community site might be able to go into more details, though I recall it was able to automate outputting information into another Excel Table automatically based on what was input. They change their connectors all the time though so it may be gone or renamed.
3 Replies
- AlexanderPrime
Solution Supplier
It's been a while since I've used PowerAutomate but if the Excel files are stored on SharePoint 365/Teams, with a bit of work it may be possible to set something up with PowerAutomate to make a record of who changed what.
I think their community site might be able to go into more details, though I recall it was able to automate outputting information into another Excel Table automatically based on what was input. They change their connectors all the time though so it may be gone or renamed.
AlexanderPrime thanks for responding!
Do you have a link to "their communicty site" - I'm not sure what that is?- AlexanderPrime
https://powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums
It's pretty much the same as this forum but it's focused on PowerAutomate.