Forum Discussion
Exporting More Than 500k Rows from Power BI – End-User Friendly Solution?
Hey,
I'm looking for a solution to export more than 500k rows from Power BI from an end-user perspective. Specifically, I need to create some kind of button that allows users to export data based on selected filters.
I’m aware of the Power Automate workaround, but it doesn’t seem very maintenance-friendly. I also know that exporting via a live connection is possible, but it requires granting users certain permissions that I’d prefer not to give.
Have you come across any other workarounds?
Appriciate all the help!
Hi SzakuBBK ,
You're almost there — and @bhanu_gautam’s logic is on the right track. Just needs a small adjustment and a visual-level filter to make it work exactly as you described.
Step 1: Create this measure
ShowRow = VAR SelectedFruits = VALUES(Table[Fruit]) VAR FruitV2 = SELECTEDVALUE(Table[Fruit v2]) RETURN IF ( COUNTROWS(SelectedFruits) > 1, IF ( CONTAINS(SelectedFruits, Table[Fruit], FruitV2), 0, 1 ), 1 )Step 2: Apply it as a visual-level filter
- Go to your table visual.
- Drag the ShowRow measure into the Filters on this visual pane.
- Set it to show only when ShowRow = 1.
This way:
- If only one fruit is selected → all rows are shown.
- If multiple fruits are selected → rows where Fruit v2 matches any selected fruit are excluded.
Let me know if you want to extend this logic to more complex filters — happy to help.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was supported by AI for translation and text editing.
5 Replies
- burakkaragoz
Super User
Hi SzakuBBK ,
You're almost there — and @bhanu_gautam’s logic is on the right track. Just needs a small adjustment and a visual-level filter to make it work exactly as you described.
Step 1: Create this measure
ShowRow = VAR SelectedFruits = VALUES(Table[Fruit]) VAR FruitV2 = SELECTEDVALUE(Table[Fruit v2]) RETURN IF ( COUNTROWS(SelectedFruits) > 1, IF ( CONTAINS(SelectedFruits, Table[Fruit], FruitV2), 0, 1 ), 1 )Step 2: Apply it as a visual-level filter
- Go to your table visual.
- Drag the ShowRow measure into the Filters on this visual pane.
- Set it to show only when ShowRow = 1.
This way:
- If only one fruit is selected → all rows are shown.
- If multiple fruits are selected → rows where Fruit v2 matches any selected fruit are excluded.
Let me know if you want to extend this logic to more complex filters — happy to help.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was supported by AI for translation and text editing.
- Sergii24
Hi SzakuBBK, I don't think Power BI natively supports what you're asking for...
- If you need to analyze the data further, consider using "Analyze in Excel", which will create a live connection to your semantic model and will allow users to analyze large volumes of data.
- When hover on a visual in top-right corner you can export the data, but it's limited to 30K rows.
- Alternatively you can create a paginated report, where users can apply necessery filters (called parameters) and download result in Excel.
- When using Direct Query, none of this solution will work if users don't have read permsission to the DB.
Good luck with your project!
v-echaithraCommunity Support
Hi SzakuBBK ,
Thank you Sergii24 for your inputs.As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.- v-echaithra
Hi SzakuBBK ,
We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E. - v-echaithra
Hi SzakuBBK ,
We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.
Best Regards,
Chaithra E.
