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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Power BI Pro can auto refresh (every 1 min) all the report pages using Direct Query

Hi Team,

This question was asked previously and wanted to know on the latest versions 

I have used a direct query option to fetch data from the SQL server in to the Power BI.

Developed a report (2 pages) in the Power BI desktop and published to the Power BI Service.

I have used lot of calculated measures and applied transformations as well.

 

Questions:

  • Can I perform a auto refresh on the all the report pages on Power BI service for every 1 min.If so, please help me on this.
  • Can auto refresh will update the measures as well for every 1 min.?

Thanks

1 ACCEPTED SOLUTION
venal
Memorable Member
Memorable Member

@Anonymous 

Please refer the link

Please post your idea/vote here in the link.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @

 

BR

@venal 

View solution in original post

6 REPLIES 6
venal
Memorable Member
Memorable Member

@Anonymous 

Please refer the link

Please post your idea/vote here in the link.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @

 

BR

@venal 

KBO
MVP

Hi @Anonymous ,

If you use direct query your report is actual whenever you open it and send queries.

You only need a Data Gateway If you have datasources which are on premises.

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Anonymous
Not applicable

Thanks @KBO 

After I set up the gateway connection, should I be able to auto refresh the report page for every one minute with power BI pro.

Hi, it is automatically a refresh if you use direct query :). No extra settings needed. Best, Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Anonymous
Not applicable

hi 

In  the power bi docs it says 

 

power bi pro had minimum auto refresh interval is 30 mins whereas 

power bi premium has 1 min .

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

 

Is there a way to refresh at 1 min interval In POWER BI PRO ?

 

thanks

 

So you are asking if there is a way to circumvent the license restrictions?

 

Raise the idea on the forum, and if enough Pro users agree then maybe Microsoft will change the terms.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors