topic Re: Extract data from a table visual from power bi using python script in Developer

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

Anonymous — Wed, 12 Oct 2022 11:01:24 GMT

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

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

Anonymous — Thu, 13 Oct 2022 08:38:29 GMT

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.

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

Anonymous — Thu, 13 Oct 2022 08:41:41 GMT

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

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

MallikarjunaBan — Fri, 08 Sep 2023 08:55:43 GMT

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