PYTHON SCRIPTS IN POWER BI

[Anonymous]

Hi,

Is there any way I can call one python script in one page from another python script in another page? I have a report to be exported to Excel and it has multiple pages. Each page has a different set of filters so I can't use the data sources from one page. Or is there a way I can define filters in the python script?

I have a script in one page which can export that page into excel using dataframe.to_excel() from pandas, but to cover data from multiple pages I should either be able to call all the scripts in one script or be able to define the filters inside the code.

Any help would be appreciated.

[V-lianl-msft]

Hi @Anonymous ,

According to my attempt, I can't directly export the data of different pages using python.

You can try to use the same data source to publish different reports, and then set the schedule refresh to export to different Excel files.

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

[Anonymous]

Hi @V-lianl-msft ,

Thanks for the reply, but I can't change the format of the report and I don't want a scheduled refresh to export rather a button click to export to excel. Is there any way I can do that? I tried using powerapps visual to create a button which is based on power automate flow but that again comes down to checking the boxes for the data to be sent in leading to the filters issue again. Any work around for that? Or how do I use power automate to export the report to excel?