Refresh every 15 direct query and import model

[nirrobi]

Hi,

I have a model with one fact with direct query and few dim with import mode.

When I upload the model to the service the option for refresh every 15 minutes is not exist (all the cashe section is missing)

(when I upload only the fact with direct query it exist)

is it normal or am I missing something?

10x 
Nir

[v-diye-msft · Accepted solution]

Hi @nirrobi 

You might refer to this similar post:

https://community.powerbi.com/t5/Service/Mixed-mode-now-refreshes-only-daily/m-p/913697 

[GilbertQ]

Hi there

The reason is because your facts are in import mode they only get refreshed based on your scheduled refresh.

You would have to change the dim tables to also be direct query to see the relevant data.