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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Data Refresh while using direct query.

How fast is the data refresh rate for a report published to the service?
Is it really instantaneous or is there a waiting period?

1 ACCEPTED SOLUTION
bajee
Resolver III
Resolver III

Hi,

 

Fast is depends on your code.Its not taking that much of time to refresh.In our project also we are using direct query reports are taking 10-15minutes to refresh the data.

 

Regards,

Bajee.

View solution in original post

3 REPLIES 3
bajee
Resolver III
Resolver III

Hi,

 

Fast is depends on your code.Its not taking that much of time to refresh.In our project also we are using direct query reports are taking 10-15minutes to refresh the data.

 

Regards,

Bajee.

Eric_Zhang
Employee
Employee

@Anonymous

Addition to @Greg_Deckler



There is a direct connection between Power BI and the database. When you interact with a visualization, queries are sent from Power BI directly to the database. To enhance performance, dashboards tiles are cached and periodically refreshed. Change the frequency here. (You can always manually refresh a tile any time by using the option on the More menu of the tile


Capture.PNG

Greg_Deckler
Super User
Super User

For direct query, there is no data refresh, you are live querying the data. The speed is determined by how fast the query can get to your data gateway, retrieve the data and return the data back to the Service.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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