cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karthikkjm
Regular Visitor

Auto Refresh Frequency Disabled

Hi,

 

Created a Direct Query Report and published to power bi service. Gateway is already configured. when trying to change the refresh frequency in the dataset, then options are disabled. How to change the refresh frequency,

 

Please refer the screenshots for more information.

 

Thanks & Regards,

Karthik K

 

 

PBI_Dataset_Refresh_Issue.png

3 REPLIES 3
GilbertQ
Super User II
Super User II

Hi there, with DirectQuery every time you interact with a visual it send the queries directly to your source. So the data is never cached. The greyed out option below is the cache refresh for dashboard items only.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi,

Data is refreshed in the Published reports (published to Web) on page refresh not on visualization selection.

But when viewing it inside the power bi service, it is refreshed only after the refresh option in power bi.

 

We are using Pro license. in pro license minimum frequency for datasets are 15 mins only.

 

But we want it to be refreshed properly in the given intervals without page refresh (for published to Web reports) and manual refresh (in power bi service).

 

Regards,

Karthik K

Hi karthikkjm,

 

If you leave the report opened before, after the new data added in source table, we need to click refresh button or refresh the browser to see updated data in power bi service. If you want to see updated data in report without refreshing manually, you can install an auto-refresh extension to your browser.

 

Regards,

Jimmy Tao

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.