Forum Discussion

Ozzy007's avatar
Ozzy007
New Member
5 months ago
Solved

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 filte...
Interesting Links
  • grazitti_sapna's avatar
    grazitti_sapna
    4 months ago

    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!

v-priyankata's avatar
v-priyankata
Community Support
4 months ago

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.

v-priyankata's avatar
v-priyankata
Community Support
4 months ago

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.

 

  • v-priyankata's avatar
    v-priyankata
    Community Support
    4 months ago

    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.