Extract data from a table visual from power bi using python script

[Anonymous]

Hi ,

Is there a way to export data from table visual using some python script. I cannot use Power Apps or Power Automate since those tools are restricted to use in our org. Usecase is very simple. Based on slicer selection by user, the table will get filtered. so the filtered table has to be exported using python scripts or however possible.

Thanks,

Priyanga

[MallikarjunaBan]

Thanks for writing this. My requirement is to export a Power BI visual content into a excel  file with 1.5 million records on average per day and save it in my local drive. Is there a way to do this as well.  specific for a table visual i need . i qlik view i could export 1million easily from table visual and need the same in power bi service .i tried using paginated report but it chokde all the memory and after 3 hrs no output as i have 42 columns in output but i could export for 5 columns only in paginated reports  @Anonymous 

[Anonymous]

Hi @Anonymous ,

As far as I know , we could export data from the whole Power BI Report instead of specific visuals to csv by Python.

You may refer to below video and blog to learn more details.

For reference:

Export data from Power BI using Python

Schedule Automated Data Exports from Power BI using a simple R/Python Script

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @Anonymous . I am able to export complete dataset using python script. but i would like to export specific  visual data only.