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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BK1234
Helper I
Helper I

PowerBI.com returns to cached data after clicking in a visual

I have a report with direct query-datasources. The data are derived from a SQL-database. 3 different tables. A refresh-datetime is available in one of the tables. This is set to the moment a refresh has been done in SQL. It occurs every 10 minutes. This time is shown in mij PowerBI-report so I can see which data is presented.

 

A strange thing happens. When I open the report in powerbi.com I have data, for example, from today 12:30. Then I manually refresh the data in the database, giving a refresh-datetime in de underlying tables of today 12:34. Then I return to the powerbi-report-window, and I click in a stacked column-visual on one of the bars. Apparantly PowerBI needs to execute the datasource-query because the presented time is changed to today 12:34. When I get rid of this selection by clicking the bar again, the presented time changes back tot 12:30. As if it returns back to cached data. This happens in .com and in desktop.

 

What is happening? And how can I make sure that the data is always (after clicking somewhere) up to date? And not returning from up-to-date data back to cached data?

2 REPLIES 2
BK1234
Helper I
Helper I

Hi Ibendlin,

Thanks for your reply! I changed the maximum allowed data cache to 0 and later to 1 but it doesn't change anything. It works the same as before.

lbendlin
Super User
Super User

In the dataset settings you can disable the cache.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors