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?
