Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
fellipea_ao
Frequent Visitor

Data Refresh in Power BI less than 30 minutes

Hello!

I have a dashboard using a data source Azure Data Lake Storage Gen2. This type of datasource dont provide the  "directy query" option.

datasourcedatasource

I published the dashboard in app.powerbi.com and scheduled atualization every 30 minutes.
However, I need to schedule it to update every 15 minutes.

 

In documentation and in app.powerbi, the minumum time to refresh is 30min.

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data

"If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings."

Example:

fellipea_ao_1-1686246618102.png


How can I schedule data refresh for this type of connection for 15min or less?

 

 

Ps: We are used to using the PBI Report Server with a SQL Server source. In this type of connection, we can schedule data refresh every 1 minute. However, using Azure Data Lake Storage Gen2 source, the PBI RS dont provide the option to schedule data referesh. So, we move to app PBI to avoid this problem.

 

https://learn.microsoft.com/en-us/power-bi/report-server/data-sources

documentationdocumentation

Example in PBI Report Sever:

PBI Report ServerPBI Report Server

 

 

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

You can use Power Automate to schedule a report refresh every 15 minutes. 

View solution in original post

3 REPLIES 3
vicky_
Super User
Super User

You can use Power Automate to schedule a report refresh every 15 minutes. 

Thank you, its worked using power automate. Now I ll try use Azure Logic App.

I used that link to guide me. 
https://towardsdatascience.com/how-to-schedule-unlimited-power-bi-dataset-refreshes-with-a-simple-po...


@vicky_  and Fellipea_ao is there an updated guide or articles on the subject? I would like to test this for some of our users but the link now leads to deleted content. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.