Forum Discussion
Power BI table export
If I export my table into excel, I am getting a line at last saying "No filters applied". Is there any option to remove it while exporting?
Hi Deva__ ,
That line — “No filters applied” — is automatically added by Power BI when you export data. It’s not coming from your table or measure.
It can not be removed but you can try alternatives:-
- Remove it in excel after export
- Use paginated reports
- Instead of exporting visual try copy and paste in excel (Right-click → Copy table)
- Use power automate (Export after cleaning the table)
🌟 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!This line is automatically appended by Power BI during export to indicate the filter state at the time of export and cannot be suppressed through any report or visual setting.
3 Replies
- grazitti_sapnaSuper User
Hi Deva__ ,
That line — “No filters applied” — is automatically added by Power BI when you export data. It’s not coming from your table or measure.
It can not be removed but you can try alternatives:-
- Remove it in excel after export
- Use paginated reports
- Instead of exporting visual try copy and paste in excel (Right-click → Copy table)
- Use power automate (Export after cleaning the table)
🌟 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!- Deva__Regular Visitor
Can you please elaborate on paginated reports approach?
- cengizhanarslanSuper User
This line is automatically appended by Power BI during export to indicate the filter state at the time of export and cannot be suppressed through any report or visual setting.