Forum Discussion
Logging Applied Filters in Power BI Report Server
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,
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!