Solved: Refresh every 15 direct query and import model

nirrobi · ‎02-27-2020

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 · ‎02-27-2020

Hi @nirrobi

You might refer to this similar post:

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

v-diye-msft · ‎02-27-2020

Hi @nirrobi

You might refer to this similar post:

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

GilbertQ · ‎02-27-2020

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.

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

Proud to be a Super User!

Power BI Blog