Frequent report updates

[stefanopigaglio]

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

[Fowmy · Accepted solution]

@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.

[Fowmy · Accepted solution]

@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]

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 · Accepted solution]

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.

[stefanopigaglio]

thanks, I'll try

[suparnababu8]

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=dis...

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!

[stefanopigaglio]

thanks, I'll try