Autorefresh versus manual refresh

[rpinxt]

So I have a model with a direct query source which works just fine.

Now I also put in an excel sheet as a source as import.

Both sources not connected with eachother.

Now I have autorefresh on for the page. On the page 1 visual based on the direct query source and 1 visual based on the excel import file.

Autorefreh runs and I can see action in both visuals. However the visual with the import query does not change to the latest data (I put in the excel file my name for testing).

However when I manual push the refresh button also the visual on the import changes to the correct data.

So what is going on? I thought an autorefresh would do the same as manually pushing the refresh button?

[rpinxt]

Ah ok thanks @PaulOlding , so it would then only work if I make the excel source as a direct query.

Thanks for pointing this out. Then at least I know what is going on 😉

[PaulOlding · Accepted solution]

Hi @rpinxt 

No, autorefresh of the page just re-queries the existing data in the model (or in the case of direct query re-queries the source).

Only a manual or scheduled refresh of the model reloads the import data.