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]

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

[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