Forum Discussion

FreddySetiawan's avatar
FreddySetiawan
Advocate II
6 years ago

PowerBI - Direct Query & Cache

HI Guys, I'm one happy student that likes to learn.   So, I'm stumble with PowerBI Desktop. I have an Azure SQL which always get new dataset as often as the user wants. I'm building report on Po...
Need Help
FreddySetiawan's avatar
FreddySetiawan
Advocate II
6 years ago

Yes, it's composite model.

And you are absolutely right, my calculated column is doing lookup to the live table to get the latest value.

 

Think of master data use case. 

The large fact table is remain static until weekend refresh, users are using data mapping tool to generate new mapping value and they want to see the new categorization near real-time (hence direct query).

 

Any idea how to for the calculated field to be recalculated? or set it to be non cache (if there's cache).

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi FreddySetiawan ,

 

Under ‘Formatting’ on the visualizations pane, find ‘Page refresh’ and click the slider to ‘On’.

Here is the reference:

https://spreadsheeto.com/power-bi-data-refresh/

 


Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
  • FreddySetiawan's avatar
    FreddySetiawan
    Advocate II
    6 years ago

    hi v-kelly-msft ,

    I tried but it doesn't refresh the viz.

    the calculated column still remain as the first time we create the column.

    the only way we can get so far is by changing the column formula, like adding dummy space, etc.