search

dubravcik / pbixrefresher-python

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

Fails to Publish if Refresher has errors #14

Open robyerevan opened 5 years ago

robyerevan commented 5 years ago

It fails to publish after refresh when there are error records in data received Power BI will show a popup window. I have to manually close the popup and the script stops there.

bramvaneerden commented 4 years ago

i found a temporary workaround for this problem, you can add a mouseclick on certain coordinates on your screen by adding this to your code after the refresh: pywinauto.mouse.click(button='left', coords=(902,586))

I also had to add in a couple time.sleep() to make sure it can execute the next steps.

To find the coordinates on your screen you can use MousePos: https://www.adminsehow.com/2012/03/realtime-mouse-position-monitor-tool/

LevonPython commented 4 years ago

You can try this way, it is quite simple. https://github.com/LevonPython/PbiRefresher

titou56 commented 2 years ago

i found a temporary workaround for this problem, you can add a mouseclick on certain coordinates on your screen by adding this to your code after the refresh: pywinauto.mouse.click(button='left', coords=(902,586))

I also had to add in a couple time.sleep() to make sure it can execute the next steps.

To find the coordinates on your screen you can use MousePos: https://www.adminsehow.com/2012/03/realtime-mouse-position-monitor-tool/

Do you have find a definitive solution ?