Display Total Rows in report for Export data (Summarized)

[Anonymous]

My report has 5 slicers (Region, Country, Branch, Fiscal Year, Quarter) and Table Visual (mainly text columns and 3 calculated measures). 

If "Select All" is checked in all the slicers, there could be > 500K rows in the Table Visual.

Report is developed to allow users to Export data so they can run further analysis.

I would like to display the 'Total Rows' (use Card Visual) some where in the report so users know they have to reduce the data rows using slicers if they want to Export data.

Because the report is summarized, I cannot use CountRows or CountA - it won't give me the correct row count.  

I tried using the concat method of all columns and then Distinct Count - it did now show correct row count either.

I have not been able to find a solution for it.    Does anyone have any suggestion i can try?  Thank you.

Export data (Summarized data) to Excel 150K row max.

Export data (Summarized data) to CSV 30K row max.

[amitchandak]

@Anonymous , there are a few options using python

https://pawarbi.github.io/blog/powerbi/python/sql/export/2020/06/23/export-powerbi-sql-python.html

https://www.thebiccountant.com/2018/12/29/export-data-from-power-bi-to-csv-using-python/