dubravcik / pbixrefresher-python

Refresh Power BI reports programmatically for free
MIT License
122 stars 54 forks source link

Not able to run the script on scheduler #34

Open pystory opened 3 years ago

pystory commented 3 years ago

Hello, Thanks for the great solution to auto refresh the Power BI Desktop. I was able to make this script work to refresh power BI file and save it. scripts works well when I run it from the code.

I created a windows task to run this script automatically. when it attempts to run this task, It opens the power bi file but not able to hit refresh button and it is giving me this error "There is no active desktop required for moving mouse cursor".

Is there any workaround to get over this issue? or is there a way we can send refresh command though key board keys?

Issue I believe I'm having right now is maybe it is not able to get active desktop when it tries to move the mouse to refresh the file, when it is running from scheduled task.

I would really appreciate any help/suggestions on this. TIA