Forum Discussion

AinSyahfiqa's avatar
AinSyahfiqa
Frequent Visitor
1 year ago
Solved

Issue with Auto-Update of Published Power BI Report on Web

Hi All, 

 

Good day.

 

I’m currently learning and exploring Power BI and would appreciate any help in resolving an issue I’ve encountered.

 

I’ve created a report in Power BI Desktop with the data source coming from the web (OneDrive). My OneDrive file is set to auto-update every 15 minutes.

 

After publishing the report to Power BI Service, I configured a scheduled refresh for the report semantic model to be update every 3 hours. The report updates as expected during each scheduled refresh in my Power BI Service.

 

However, after publishing the report to the web (public), the data does not update on the published report, even though the manual and auto-refreshes in Power BI Service are working fine.

 

Could anyone advise what steps I can take to ensure the published report updates automatically without needing to refresh the browser?

 

Thank you.

  • Hello AinSyahfiqa,

     

    There is a Chrome extension available for automatically refreshing Power BI visuals(To be honest I haven't used it because it is not available in my job computer.):

    Power BI Visuals Auto Refresh Extension

    However, I personally prefer using my own method to enable auto-refresh with HTML code.

    You can follow the link below to learn how to implement it:
    Advanced Automation: Seamlessly Refresh and Navigate Power BI Pages, Reports, and Dashboards

     

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

  • Hi AinSyahfiqa 

    I understand you're facing an issue with the auto-update of your published Power BI report on the web. Based on your setup, it appears that the auto-update feature is only available with DirectQuery and live connection methods.

    To ensure your published report updates automatically without needing to refresh the browser, you should consider using either DirectQuery or a live connection. These methods allow for real-time data updates and dynamic querying, which should address the issue you're experiencing.

    If you have any further questions or need additional assistance, feel free to ask!

     

    If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily. 

    Hope this works for you! 

    Thanks. 

     

11 Replies

  • Hello AinSyahfiqa,

     

    There is a Chrome extension available for automatically refreshing Power BI visuals(To be honest I haven't used it because it is not available in my job computer.):

    Power BI Visuals Auto Refresh Extension

    However, I personally prefer using my own method to enable auto-refresh with HTML code.

    You can follow the link below to learn how to implement it:
    Advanced Automation: Seamlessly Refresh and Navigate Power BI Pages, Reports, and Dashboards

     

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

    • AinSyahfiqa's avatar
      AinSyahfiqa
      Frequent Visitor

      Hello @uzuntasgokberk,

       

      Thank you so much for your reply.

       

      I tested the Chrome extension, but it seems it did not refresh my Power BI report. I also tried using it with a different account, but it still didn’t seem to work.

       

      Regarding the HTML code, may I know if you ran the code on a server? I assume the HTML code needs to keep running continuously to enable the refresh right? Also, would it be possible to share the published report with other people as well?

       

      Looking forward to your guidance.

      • uzuntasgokberk's avatar
        uzuntasgokberk
        Icon for Super User rankSuper User

        Hello AinSyahfiqa ,

         

        The HTML code only enables automatic web refresh and does nothing beyond that(such as not refresh the dataset etc.), as I have implemented it this way.

        If you have a mini computer that needs to display content on a television (as in my case), the only requirement is to open the HTML file. However, it must be a computer; I haven't tested it on a server, so I cannot confirm whether it would work in that environment.

        If you'd like to share your report, you have several options, such as publishing to an app or using embedded code, as shown in the image below.

         

        Kind Regards,
        Gökberk Uzuntaş

        📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

        🔗 Stay Connected:
        📘 Medium |
        📺 YouTube |
        💼 LinkedIn |
        📷 Instagram |
        🐦 X |
        👽 Reddit |
        🌐 Website |
        🎵 TikTok |

  • Hi AinSyahfiqa 

    The "Publish to Web" feature creates a static snapshot, so updates from the Power BI Service don't appear automatically.

    Solutions:

    1. Use "Embed in a Website or Portal" instead of "Publish to Web" for dynamic updates.
    2. Add a JavaScript auto-refresh if embedding in a custom webpage.
    3. Align Power BI Service refresh schedules with your OneDrive updates.
    4. Clear browser cache or force-refresh (Ctrl + F5) for the latest view.

    For real-time updates, embedding via Power BI Service is the best option.

     

    Did I answer your question? Mark my post as a solution, this will help others!
    If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

    Kind Regards,
    Poojara
    Data Analyst | MSBI Developer | Power BI Consultant
    Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

    • AinSyahfiqa's avatar
      AinSyahfiqa
      Frequent Visitor

      Hi Poojara_D12,

       

      Thank you for your reply.

       

      However, it seems that when I use the embedded report on a website or portal (not the public one) and create a code for auto-refresh, the report cannot be opened at all. It shows a message saying "Please sign in to view the report."

       

      Additionally, when I open the report using the link after publishing it to the website or portal (not public), the report remains static as well.

       

      Can you help me figure out how to resolve this?

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support

    Hi AinSyahfiqa 

    I understand you're facing an issue with the auto-update of your published Power BI report on the web. Based on your setup, it appears that the auto-update feature is only available with DirectQuery and live connection methods.

    To ensure your published report updates automatically without needing to refresh the browser, you should consider using either DirectQuery or a live connection. These methods allow for real-time data updates and dynamic querying, which should address the issue you're experiencing.

    If you have any further questions or need additional assistance, feel free to ask!

     

    If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily. 

    Hope this works for you! 

    Thanks. 

     

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support

    Hi AinSyahfiqa 
    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
    Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support

    Hi AinSyahfiqa 

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support

    Hi AinSyahfiqa 
    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
    Thank you.