Forum Discussion
Logging Applied Filters in Power BI Report Server
Hi everyone,
I’m currently working with Power BI Report Server and looking into ways to improve auditing and logging for compliance purposes.
Is there a simple way to capture or log the filters (e.g. slicers or parameters) that a user has applied when viewing a report?
Ideally, I would like to record:
- The selected filters or parameters
- Ideal the output
- The user who executed the report
- The time of execution
I’m aware of the ExecutionLog, but I’m not sure if it fully captures interactive filter states from reports.
Has anyone implemented something similar or found a good approach?
Thanks in advance!
Hi Ozzy007,
Unfortunately, there is no native way in Power BI Report Server to capture slicer/filter selections (interactive state) in logs.
But you can simulate it
1. by creating measures and write back to a table in shared location on Sharepoint/Onedrive
2. Creating field parameters, use them in slicers and then writing back to the SQL source table
Attached is a .pbix file to showcase how you can create a table and then you can write this information back to the table, depending upon how you want to set it up (Sharepoint or SQL)
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
4 Replies
Hi Ozzy007,
Unfortunately, there is no native way in Power BI Report Server to capture slicer/filter selections (interactive state) in logs.
But you can simulate it
1. by creating measures and write back to a table in shared location on Sharepoint/Onedrive
2. Creating field parameters, use them in slicers and then writing back to the SQL source table
Attached is a .pbix file to showcase how you can create a table and then you can write this information back to the table, depending upon how you want to set it up (Sharepoint or SQL)
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!Hi Ozzy007
Thank you for reaching out to the Microsoft Fabric Forum Community.
grazitti_sapna Thanks for the inputs.
The suggestion from the user was helpful. As mentioned by the Super User, Power BI Report Server does not natively capture slicer or filter selections in its logs.
In addition to user points, one approach is to use report parameters for the most important filters. These values can be captured in the ExecutionLog along with details like the user and execution time. While this isn’t a perfect replacement for slicers, it does help from an auditing perspective.
If complete visibility into all interactive filter selections is required, it would typically need a custom embedded solution, as this isn’t supported out of the box in Report Server.
If there are any deviations from your expectation please let us know we are happy to address.
Thanks.
Hi Ozzy007
Thank you for reaching out to the Microsoft Fabric Forum Community.
I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hi Ozzy007
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.
