Export data from Power BI

Hi hchava5292​ 

You can use a paginated report through Power BI Report Builder which is built on the same semantic model from live/XMLA connection. Pass the main report filters and field selections into it as report parameters where parameters will do row filtering and column visibility giving the same checkbox field selection. Because paginated reports make the semantic model RLS/OLS and have no row limit where users get single Export button that handle filters, security, and outputs Excel or CSV with unlimited rows and no visual export involved.