cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

AutoHotKey Script for auto-refresh in Power Bi Desktop

Hello Community,

 

I have written a script in AutoHotKey for Power Bi Desktop to auto-refresh by hiting Alt - H - R. This is a combination that does work in Power Bi Desktop when done manually. The AutoHotKey code I wrote is below. This code works within Microsoft Word (r activates the replace command) and Excel (not r, but tried it with x, which activates the Cut command), but will only open the Power Bi window and will not activate the refresh button. Does anyone have an idea as to why it will not work in Power Bi Desktop?

 

--------------------------------------------Code----------------------------------------------------------------------------

#NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases.
; #Warn ; Enable warnings to assist with detecting common errors.
SendMode Input ; Recommended for new scripts due to its superior speed and reliability.
SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory.

 

#Persistent
SetTimer, PressTheKey, 30000     ;Refresh every 30 secs (Power Bi Desktop cannot do this and this is important for                                                          ;what I am trying to do)
Return

 

PressTheKey:
if WinExist("Test File")
{
WinActivate       ;Activate the window (if it is not the current window it will reopen it and allow you to work in it)
WinMaximize     ;Maximize window
Send !hr             ;Alt h r keys
}

 

Esc::ExitApp      ;Press "Esc" key to end code
return

-----------------------------------------------------------------------------------------------------------------------------

 

P.S. If anyone knows a shortcut key for refresh in Power Bi Desktop that would be helpful too.

2 ACCEPTED SOLUTIONS
Frequent Visitor

If you're up for a bit of python, there's a scipt here that is quite a useful demo of using pywinauto to do just this sort of thing:

https://github.com/dubravcik/pbixrefresher-python

 

View solution in original post

Oh that is pretty neat! Thank you for sharing! The autohotkeys script works too, but it needs to be run as administrator. I found that out a little after posting this. But thank you for your reply!

View solution in original post

2 REPLIES 2
Frequent Visitor

If you're up for a bit of python, there's a scipt here that is quite a useful demo of using pywinauto to do just this sort of thing:

https://github.com/dubravcik/pbixrefresher-python

 

View solution in original post

Oh that is pretty neat! Thank you for sharing! The autohotkeys script works too, but it needs to be run as administrator. I found that out a little after posting this. But thank you for your reply!

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.