Extract the data from table visual in power bi using power automate [100K limits ]

[Ahmed_Khalil]

i have power bi report and in the canvas there is a table visual and some slicers, what i need is to create a flow that when user make some filteration based on slicers then extract the data from the table visual to excel or csv table 

i know that there's a limit 1000 rows but i need it to be 100K rows or more

[rubayatyasmin]

Hi, @Ahmed_Khalil 

you can follow this article on how to use Power Automate to export data. 

Export Power BI data to CSV via Power Automate visual and upload to SharePoint - CloudFronts

If you want to use power automate then you will have to cinsider the limitation. 

also, found these articles that may be of help. 

Solved: export data from power bi visuals to excel automat... - Microsoft Fabric Community

Power Automate Export is limited 1000 Rows - Issue - Power Platform Community (microsoft.com)

Solved: Re: Power Automate - Export Button - Microsoft Fabric Community