pbixrefresher-python icon indicating copy to clipboard operation
pbixrefresher-python copied to clipboard

Fails to Publish if Refresher has errors

Open robyerevan opened this issue 7 years ago • 3 comments

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.

robyerevan avatar Oct 25 '18 05:10 robyerevan

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/

bramvaneerden avatar Dec 20 '19 08:12 bramvaneerden

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

LevonPython avatar Mar 31 '20 10:03 LevonPython

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 ?

titou56 avatar Jun 27 '22 13:06 titou56