Chrome Extension to auto refresh Power BI report.

Chrome Extension to auto refresh Power BI report.

Requirement  : 
Power BI report will be visible on monitor/projector and team will monitor it live.
Report needs to refresh on it's own every 5 seconds.

Power BI :
We created report with SQL direct query so report shows current data when accessed or clicked refresh on report.
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery


Solutions :

#1 : 
Refresh full page every x seconds
https://chrome.google.com/webstore/detail/auto-refresh/ifooldnmmcmlbdennkpdnlnbgbmfalko?hl=en-US

Issues with above solution :
Extension refreshes full page (browser refresh) so screen becomes blank for second(s).
If user want to click on report and see the data, it can cause issue if page refreshes at same time.

#2 :
Created new chrome plug in / Extension so it will click refresh button after N (seconds) interval, so it will only make AJAX call and refresh report data (not entire page).

https://chrome.google.com/webstore/detail/auto-refresh-powerbi-repo/nnigckpadeknonmjogfefhaddaegfmnn


Please leave comment if you find it useful or encounters any issues.


Comments

  1. UnknownSeptember 17, 2019 at 12:22 PM

    Can you close the pop up once user clicks on start and continue refreshing the report in background. Having the popup open all the time limits its usage.
    Otherwise it works as expected. Great work!!!

    ReplyDelete
    Replies
    1. gaurav ghodnadikarNovember 17, 2020 at 12:51 PM

      Sorry, but I left the pop-up open so you can change the frequency if needed.
      And user can always click on "close" button to hide the pop-up.

      Delete
  2. gaurav ghodnadikarSeptember 17, 2019 at 12:37 PM

    Thanks for 5* and your feedback, only reason I kept pop-up open so that users can change frequency without opening extension pop-up again and again. But I like your idea, will add new button "start and close".

    ReplyDelete
  3. UnknownJune 25, 2020 at 6:55 AM

    I am trying to write an extension with similar functionality to yours because I like the way that your extension works (trying to learn some javascript along the way) I was wondering how you accessed the refresh button? I'm trying to sift through that menu dynamically to find the refresh button specifically, but Microsoft has disabled all of the properties such as getChildElementCount and ariaRowCount

    ReplyDelete
    Replies
    1. gaurav ghodnadikarJuly 5, 2020 at 8:38 AM

      Send me your email address and details, I will send you code via email.

      Delete
  4. KrishikaJuly 9, 2020 at 1:56 AM

    Hi Gaurav
    I am trying to recreate the same on my end. Can you send over the code on my email ID if possible.

    ReplyDelete
  5. dutch.mafiaJuly 29, 2020 at 11:37 AM

    Can this be programmed into a Raspberry Pi command prompt?

    ReplyDelete
  6. UnknownSeptember 3, 2020 at 1:40 AM

    great work Gaurav. can you please send me code via email?

    ReplyDelete
  7. Gonzalo UvizDecember 31, 2020 at 12:09 PM

    Hi, this work perfect.
    Is any chance refresh only data also but in a Report Server dashboard?

    ReplyDelete
  8. TaherJanuary 11, 2021 at 4:15 AM

    Very good work Gaurav. can you please send me code via email "tgtaher2008@gmail.com"?
    I search for this solution a lot of time, I apricate your support .

    ReplyDelete
    Replies
    1. gaurav ghodnadikarFebruary 5, 2021 at 11:53 AM

      Hi Teher, send me email what are you looking for. and I will surely help you.

      Delete
  9. vissvessJanuary 26, 2021 at 10:48 PM

    Hi Gaurav. Will this extension work for Power Bi service Dashboard.?

    ReplyDelete
  10. windrekMarch 24, 2021 at 4:21 AM

    Dear Guarav,
    Excellent idea but...
    Should this extension create some popup for user to define refresh interval?
    We try to use it and nothing happens, popups are enabled.
    That means no refresh also.
    Chrome is 64 bit latest version
    Regards,
    Indrek

    ReplyDelete
    Replies
    1. gaurav ghodnadikarMarch 24, 2021 at 1:29 PM

      There is a pop-up that allows user to have own interval.
      Send me screen shots and debug log, I can take a look at it.

      -Gaurav

      Delete
  11. Martinho VasconcelosMay 24, 2021 at 4:17 PM

    Hi,
    Great job Gaurav!!!
    Is it possible to send me the code? Other thing I'm trying to put it in kiosk mode in a raspberry pi, how can I run it when the chrome starts? is it possible?
    Thank you and once again great job

    ReplyDelete
    Replies
    1. ScopienSeptember 16, 2021 at 11:36 PM

      That's exactly how I want it to work too. Did you manage to find a solution to this?

      I want my reporting dashboard pc to load chrome in full screen mode and have this timer start automatically.

      Delete
  12. Chris LesnarMay 25, 2021 at 3:48 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  13. UnknownNovember 1, 2021 at 9:34 AM

    What happens if you have multiple Power BI report pages open in your browser?

    Does this initiate a refresh schedule for the report page you are on, or for all .powerbi.com sites you have currently open?

    Is it possible to use this extension for multiple Power BI tabs at once?

    ReplyDelete

Post a Comment

Popular posts from this blog

Dataverse D365 REST Web Api using client secret From Postman or Power Automate desktop (PAD) .

Image
  How to call Dataverse REST Web Api from postman or power automate desktop. Note:  <Value>: Either custom value or value from previous steps. What do we need? - Postman:  Download Postman | Get Started for Free - PAD:  Install Power Automate - Power Automate | Microsoft Learn - D365 environment URL - O365 Entra/*Global admin.   ----X---- Let's get started. Register an app using MS Entra Platform:  Go to: https://entra.microsoft.com/ -> Identity -> Applications -> App registrations -> New registration Official link: https://learn.microsoft.com/en-us/entra/identity-platform/quickstart-register-app   Name: <Provide Name> Supported account types: Single tenant. Redirect URI: https://localhost Update Manifest file: Set oauth2AllowImplicitFlow to true. Grant Permission to access Dataverse (AKA Dynamic CRM) API Permissions -> "+ Add a permission" "User_impersonate" -> "Add permissions" Grant API Permissions (Note: Only...
Read more

How to call SharePoint online rest APIs using postman?

How to call SharePoint online rest APIs using postman? Step 1: Install Postman:  https://www.getpostman.com Step 2: Generate Client ID and Client Secret               Use below URL (Update Initial part):               <SPO Site Collection URL>/_layouts/15/appregnew.aspx               Note :                You can visit below URL to see all registered apps.                 <SPO Site Collection URL>/_layouts/15/AppPrincipals.aspx Step 3: Grant correct permissions to app and authorize it.                Use below URL (Update Initial part) : <SPO Site Collection URL>/_layouts/15/appinv.aspx Example of  permissions XML : Full control on site collection (Please do not change site collection URL or any ...
Read more