Letting users select individual records for export

Hi Zoe7294,

We appreciate your query raised through the Microsoft Fabric Community Forum.

Based on my understanding, Power BI does not natively support the selection and persistence of individual records across varying filter contexts (such as checkboxes), owing to its stateless filtering engine. Consequently, selections reset whenever filters are changed.

To accomplish your requirement of enabling customers to select multiple products for export, even when filters change, we recommend leveraging the Power Apps visual integration within Power BI.

Please follow the steps outlined below which may assist in resolving your issue:

1. Add the Power Apps visual to your Power BI report.
2. Pass the relevant fields (for example, Product ID, Name) to this visual.
3. Create or connect to a Power App that displays the items with checkboxes, allowing users to select items and save their selections in SharePoint, Dataverse, or Excel Online.
4. Use this stored list to generate a separate visual or page in Power BI for exporting the selected records.
5. The selections will persist across slicer or page changes, and users may export the selected list using Power BI export options, Power Apps export capability, or automated workflows such as Power Automate.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries. Should you have any further questions, please do not hesitate to contact the Microsoft Fabric community.

Thank you.