Forum Discussion

stefanopigaglio's avatar
stefanopigaglio
New Member
1 year ago
Solved

Frequent report updates

Good morning everyone, I'm new to power bi and I need to update a report every minute but the licenses limit me to 8/48 daily updates. Do any of you know solutions to update a report so frequently? Thank you

Tutorial Requests
  • Fowmy's avatar
    Fowmy
    1 year ago

    stefanopigaglio 

    If refresh by minute is needed, I would suggest you consider Direct Query.

    DirectQuery lets Power BI pull data directly from the source without having to refresh the whole dataset in Power BI. This means your report always shows live data, and whenever someone interacts with it (like applying filters or slicers), Power BI queries the data source in real time.

    With DirectQuery, you don’t need to worry about frequent refreshes, and updates happen as often as the data source allows.

  • v-menakakota's avatar
    v-menakakota
    1 year ago

    Hi stefanopigaglio ,

    Thank you for reaching out to us on the Microsoft Fabric Community Forum.

    Unfortunately, 'Publish to Web' does not support DirectQuery or live updates.
    To work around this here are few suggestions:

    Instead of 'Publish to Web', you can share your report via the Power BI Service and set up a scheduled refresh (or) If you’re using Power BI Pro or Premium, Auto Page Refresh allows reports to refresh at a set interval when viewed within Power BI Service.

    If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
    Regards,
    Menaka.

6 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    1 year ago

    stefanopigaglio 

    If refresh by minute is needed, I would suggest you consider Direct Query.

    DirectQuery lets Power BI pull data directly from the source without having to refresh the whole dataset in Power BI. This means your report always shows live data, and whenever someone interacts with it (like applying filters or slicers), Power BI queries the data source in real time.

    With DirectQuery, you don’t need to worry about frequent refreshes, and updates happen as often as the data source allows.

    • stefanopigaglio's avatar
      stefanopigaglio
      New Member
      1 year ago

      Hi Fowmy, I tried using direct query and now I no longer have update limits but if I publish the report on the web (public) it doesn't update. Is there any solution to this?

      • v-menakakota's avatar
        v-menakakota
        Community Support
        1 year ago

        Hi stefanopigaglio ,

        Thank you for reaching out to us on the Microsoft Fabric Community Forum.

        Unfortunately, 'Publish to Web' does not support DirectQuery or live updates.
        To work around this here are few suggestions:

        Instead of 'Publish to Web', you can share your report via the Power BI Service and set up a scheduled refresh (or) If you’re using Power BI Pro or Premium, Auto Page Refresh allows reports to refresh at a set interval when viewed within Power BI Service.

        If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
        Regards,
        Menaka.

  • suparnababu8's avatar
    suparnababu8
    Super User
    1 year ago

    Hello stefanopigaglio 

     

    You can go with Power Automate to schedule PBI report refresh for n number of times per day. You can go through below blogs and videos urls. you will get the solution for your issue.

     

    https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/?cdn=disable

    https://databear.com/power-automate-to-refresh-a-power-bi-report/

     

    https://www.youtube.com/watch?v=EXA3rif8gX8

    https://www.youtube.com/watch?v=-8NlEeIIRiQ

     

    Please let me know if it works.

     

    Thank you!

     

    Did I answer your question? Mark my post as a solution!

    Proud to be a Super User!