Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PYTHON SCRIPTS IN POWER BI

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 differ...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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?