All language subtitles for 16. Configuring Power BI Query Refresh Settings

Next up I want to take just a second to talk about refreshing queries.

Now in the Home tab of your power be I file outside of the query editor.

You see this refresh button across all of your views and by default when you press that button it's

going to refresh every single query every connection every table that exists in your model by default

but you can customize these refresh options.

So within the query editor in that queries pain can actually right click any one of your individual

connections or tables and you can simply de-select or uncheck that box that says include in report refresh.

And as you might expect that prevents that file from refreshing whenever you hit that refresh command

from the Home tab.

So helpful protip here.

What you can do is exclude all of your queries that don't change often or don't change at all like your

lookup tables aren't a static data tables that you might have.

So let's go ahead and open up the query editor and make some of these adjustments ourselves.

All right.

So here I am back in my query editor see my four queries or connections here and when I right click

each one of these you'll see that include in a report refresh line and I see a checkbox which means

that each one of these tables product customer calendar and sales will all refresh with the report.

In fact if I just go back to my relationships view here and press refresh you'll see all four of these

tables are evaluating processing refreshing.

So essentially power be-I is going to those source paths and refreshing the data and the CXXVI even

if nothing has changed.

So there you go.

It's just refreshed all four tables.

Now hop back into the query editor and what I want to do here is actually prevent my three lookup tables

from refreshing when I hit that command.

Because at least for the time being I'm not going to be adding information about products about customers.

I don't need to add more dates to my calendar but just for the sake of example let's keep A.W. sales

as is.

Let's allow the sales data to refresh so I can simply right click and click that include and report

refresh option which just de-selected it to do the same thing for customer and the same thing for calendar.

And now when I close and apply and press refresh again only that A.W. sales table was loaded.

And you see that it worked a lot more quickly that time.

That's because we're not refreshing three queries that aren't including a more data it's just redundant.

It's a little bit inefficient and slow.

So again good rule of thumb if you have data that's static if you have tables that aren't going to be

changing go ahead and exclude those from the report refresh and only refresh the ones that may be changing

over time.